Listing the particular record by mentioned the record number
I'm new to LN Programming. I want to read a record one by one from the baan table by mentioned the record number like in MySQL "select *from employee limit 2,1" which read the second record only. Similarly can you please let me know that how to read a particular record in the baan table by mentioned the record number.
Thanks and Regards,
LN people probably have something different - but in 4c4 I would never read a specific record like that. But if I new I needed exactly 2 records I could use something like this:
Thanks for your reply....
But I want to read the record one by one from the source table and also need to store it some another table. So can you please tell me how to read the record one by one without mentioned any condition in where clause until the end of record is reached...
In Baan Sql,limit and offset function are not there while writing Sql query.
so if you want read record and also offset some record like in query you offset in 1 record.you can do this like below
|it will loop all record in table
| select other table
|end of search after looping all record this section will executed.
use as set with n rows to limit recordset.
offsetting the recordset can be done in selectdo section.but no direct function available.
Thanks a lot for your information.... I'll try to the task by using the set with no row option...
|All times are GMT +2. The time now is 10:30.|
©2001-2018 - Baanboard.com - Baanforums.com