Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INSERTING into SQL server table from VFP Cursor
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
00985368
Message ID:
00985375
Views:
31
You cannot. You have to SCAN..ENDSCAN on VFP cursor and do INSERT INTO using SQLEXEC() one row at a time.

>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
- Jayesh
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform