>For different purposes, I'm using the SQL Select * From (lcCursorName) Into (lcCursorName).
>However, when I have a cursor made by a SQL 'Select Into Cursor' command and then Use that cursor Again to make it read-writable, this trick of selecting into itself doesn't work anymore. Can anyone tell me what's happening here and how I can work around it (apart from creating the cursor with 'Create Cursor')?
Mark,
Other than some cleanup benefits cursors are "always" written to disk. IMHO take the easy way and select into table.
OTOH if you have a DBC open (or create a temp one) you could create-drop a temp view on the fly.
Cetin
