-   Operating Systems & Databases (
-   -   Cursors in LN 10.2 (

penahill 4th October 2016 05:50

Cursors in LN 10.2
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
Do logic

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.


bhushanchanda 4th October 2016 06:52

You can use Dynamic SQL

All times are GMT +2. The time now is 01:23.

©2001-2017 - -