Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
INSERTING into SQL server table from VFP Cursor
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Network:
Windows 2000 Server
Database:
MS SQL Server
Divers
Thread ID:
00985368
Message ID:
00985375
Vues:
30
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform