>>Hi All:
>> I have two cursors that I want to keep open. My problem is that when I open the second cursor, it closes the first one. How can I keep both cursors open?
>>Thanks
>>MA
>
>use mySecondCursor in 0 && First free area
>or
>select 0
>use mySecondCursor && Now your second cursor is also selected - difference with the above syntax
Rnot cursors "use"`d (have an alias assigned) when created, IOW: I thought all that was needed was a select.
sqlexec(nHandle,[execute getAllCustomers],[MyCursor1])
sqlexec(nHandle,[execute getAllInvoices],[MyCursor2])
select MyCursor1
brow
select MyCursor2
brow
.. the 'use' implies the cursor was closed, in which case in wouldn't exist, right? I bet the original thread meant table, instead of cursor.