Hi,

I want to check the end of table in baan script. Does any one knows how to check the same.

regards,

George

Hi George,

what do you mean with end of table.

DB tables are dynamic.

select - from - where
you get a recordset with all information you want.

Hi bern,

if I have 10 rows in table A and my logic is below -

select A.*
from A
selectdo

in this area i want indenty the 10 record and is there any statement in baan i can check for the last record

endselect

regards,

George

If you ONLY need the last record, you do
select a.*
from a
order by a._indexX desc |this fetches the records in descending order, and thus you only need the first record
as set with 1 rows

If you need to fetch all the records, but on the last one you need to perform a specific action then you do like this:
select a.*
from a
order by a._indexX
selectdo
selecteos |this section is executed after the last record is fetched
endselect

For any further questions, don't hesitate...

Good luck,

En

hi En,

Thanks the problem was sloved.

regards,

George