OK....so far so good, however, if I attempt to use the cursor as the parent of a JOIN, the result set is empty. If I use the original table, the result set works as usual.

Example, This works, (natch)


SELECT * from ORDER, ITEMS
where order.itemid=items.itemid


However, the following does not:


SELECT * from ORDER INTO CURSOR curOrder NOFILTER

SELECT * FROM curOrder, Items
WHERE Items.itemid=curOrder.itemid



This returns an empty set.

Curious. --- L