General information
Title:
INSERTING into SQL server table from VFP Cursor
Environment versions
Network:
Windows 2000 Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only