>This works graet except when I try it a second time. Then I get an error that alias name is already in use. The original cursor sql will have a when statement bases on user input. The user may need to generate several list with different inputs.
You will need to check if myUpdatableRLS3 is open before you do requery your SQL/USE ... AGAIN and close it if it is there.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison