Larry,
I don't see any reason while it shouldn't work. Both selects should return the same set of records. Are you sure you are using the same ORDER and ITEMS for both of them? Actualy there is a small problem. The ORDER is reserved word and is apart of ORDER BY clause. Try to rename your table to ORDERS and see what happend.
>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
>SELECT * from ORDER INTO CURSOR curOrder NOFILTER
>SELECT * FROM curOrder, Items
> WHERE Items.itemid=curOrder.itemid
>
>
>This returns an empty set.
>
>Curious. --- L
--sb--