Hi,

I have a VFP cursor "invtotals"
I want to INSERT the entire cursor "invtotals" into SQL Server 2000 table "u_Holds".

If I were updating VFP tables I could use something like the following
Insert into u_Holds (u_cpono,u_cinvno)
values (Select po,inv FROM invtotals WHERE choldbo='BO')

How do I do this using the SQLEXEC command ?

Thanks in advance
Carmel