[SQL] Re: Return cursor

2001-05-28 Thread Sergey E. Volkov
If you are planing to use ecpg : exec sql declare cuserbase cursor for select column1, column2, column3 from my_table order by 1; exec sql open cuserbase; exec sql whenever not found do break; while ( true ) { exec sql fetch cuserbase into ... // do same work } exec sql close cuserb

[SQL] Re: Return cursor

2001-05-28 Thread Alla
"Sergey E. Volkov" <[EMAIL PROTECTED]> wrote in message news:<9ej088$ulc$[EMAIL PROTECTED]>... > If you are planing to use ecpg : > > exec sql declare cuserbase cursor for > select column1, column2, column3 from my_table order by 1; > exec sql open cuserbase; Thanks, but this is exactly w