I am performing a Select command on a cursor and wish the result to be sent to the same cursor. This is fine if it is a single select statement but if i perform a union within the statement it wont allow me to use the cursor twice and comes up with an open table dialogue box. I have tried sending
the result to a different cursor and then after the search has finished sending it back to the origanal one but then i get an error saying " table
must be created using select into table"
If anyone got any ideas on this I would be grateful for a reply
Thankyou in advance
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only