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
-- Larry Keyes
Remember only You can prevent Gray Goo. Never release nanobot assembers without replication limiting code.