Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Multiple SQL Commands in SPT to Oracle
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Multiple SQL Commands in SPT to Oracle
Divers
Thread ID:
00941330
Message ID:
00941330
Vues:
71
Has anyone figured out how to submit more than one SQL - INSERT command in ONE SQLEXEC() function? For example, the following does not work:
TEXT TO lcSQL NOSHOW PRETEXT 1
   INSERT INTO MyTable (KeyID, Descript) VALUES (1, 'Test')
   INSERT INTO MyTable (KeyID, Descript) VALUES (2, 'Test')
ENDTEXT
? SQLEXEC(lnHandle, lcSQL)
Even with a semi-colon after each INSERT command does not work. TIA!
Mark McCasland
Midlothian, TX USA
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform