Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INSERTING into SQL server table from VFP Cursor
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
INSERTING into SQL server table from VFP Cursor
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
00985368
Message ID:
00985368
Views:
148
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
Map
View

Click here to load this message in the networking platform