Baanboard.com

Baanboard.com (http://www.baanboard.com/baanboard/index.php)
-   Tools Development (http://www.baanboard.com/baanboard/forumdisplay.php?f=8)
-   -   count(*) not working (http://www.baanboard.com/baanboard/showthread.php?t=71149)

AnuKass 12th June 2018 09:27

count(*) not working
 
hii...
i'm new for LN programming ...
here my program..
select * from tccom951
where (select count(*) from tccom951) < 1
selectdo
enable.commands(add.set)
selectempty
disable.commands(add.set)
endselect
but it's not working ...
did i any mistake here???
pls help me...:confused:

becks2203 12th June 2018 11:38

Hi wat you are trying to achieve here ..If you could tell please

AnuKass 12th June 2018 12:23

hi
 
i'm try to insert max of one record in a table
if one record inserted add.set command will be disable otherwise enable ..
i found it ...
select count(*):row from tccom951
endselect
if row < 1 then
enable.commands(add.set)
else
disable.commands(add.set)
endif
it's work perfectly ....:):)


All times are GMT +2. The time now is 06:52.


vB.Sponsors
©2001-2018 - Baanboard.com - Baanforums.com