Cursors in LN 10.2
Baan: ERP LN 6.1 FP8 (Infor ERP 10.2)
DB: Oracle 8.0.3.x
OS: HP-UX 11.31
I am trying to find out if I can use a prepare/cursor logic to query data in LN. I am coming from an Informix background using 4gl and very green in LN
Let me give an example of an Informix 4gl cursor logic I would like to use in LN:
let sql = 'SELECT item, price, on_hand FROM table_a '
' WHERE item = ', s.item, 'AND company = ' compr
PREPARE cp_cursor FROM sql
DECLARE cx_cursor FROM cp_cursor
FOREACH cx_cursor INTO p.item, p.price,p.on_hand
I know the FOREACH loop is the selectdo in LN but I would like to build a sql where clause in a string so I can use the input field(s) values to help in getting to the data quicker and more accurate.
Thanks in advance for your response.