>lnResult = sqlexec(nConnHandle, "insert into asist.dbo.sales select * from FoxLocalCursorSales" >No, you cannot. What're you trying to do? There could be other ways to achive what you want. For example, you can use How to make SQL Pass-Through cursor updatable FAQ #8153
lnResult = sqlexec(nConnHandle, "SELECT * FROM asist.dbo.sales WHERE 1=2", "crsSales" * Make crsSales updatable ... SELECT crsSales APPEND FROM (DBF("FoxLocalCursorSales")) = TABLEUPDATE()