Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiple SQL Commands in SPT to Oracle
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Multiple SQL Commands in SPT to Oracle
Miscellaneous
Thread ID:
00941330
Message ID:
00941330
Views:
73
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
Next
Reply
Map
View

Click here to load this message in the networking platform