<snip>
> I also want to get your help on copying a table from a SQL table,i.e., I am storing some output into a cursor.And the command "Copy to xyz" is giving me error. "The table is already in the database". Is it possible to copy from cursor,i.e.,temporay table to a table which already exists.

It's better to post unrelated questions in the separate threads.

SELECT 0 
USE MyTable EXCLUSIVE 
ZAP 
APPEND FROM ( DBF("MyCursor"))