>Hi, Jaime-
>
>>a2. i don't understand exactly what you mean. Normally, if the cursor is not in the DE, you can't run a SELECT unless you manually USE it. Also, you can use a cursor ( even from another SELECT ) in a new SELECT statement, as long as you don't close the cursor.
>
>PMFJI, I think I may misunderstand what you're saying, but wanted to clarify that of course you can issue a Select - SQL command on tables not in a form's DE. Sorry if I'm misunderstanding you.

Nancy
TYFJI ( i guess UT won't auto-expand this one, it means Thank You for jumpin in ). When reading my statement, i understand speaking mainly hebrew, spanish and french in the last 10 years did a good job to my english grammar.
What i meant is either you have the table/cursor in the DE, or else you should issue a USE... to the tables involved in the SELECT then run the select. I know you could run the SELECT without using the tables, but then you should either enter the full path of the tables involved inside the SELECT statement, or your environment should have a PATH statement to the data directory where the tables reside. Since i didn't know for sure if Nir did set up the environment this way, i rather recommended to USE the tables before...

Jaime