Oracle and VB 4.0
Date: 1997/12/05
Message-ID: <01bd01d5$b609cf80$24f9e59b_at_tmcateernt>#1/1
In VB 4 and SQL Server, I can send a group of SQL Statements via RDO that looks like this...
sSQL = sSQL & "Insert into Table1 (ID, Column1, Column2) values (1,
Coltext, ColText);" & vbcrlf
sSQL = sSQL & "Insert into Table1 (ID, Column1, Column2) values (2,
Coltext, ColText);" & vbcrlf
sSQL = sSQL & "Insert into Table1 (ID, Column1, Column2) values (3,
Coltext, ColText);" & vbcrlf
sSQL = sSQL & "Insert into Table1 (ID, Column1, Column2) values (4,
Coltext, ColText);" & vbcrlf
sSQL = sSQL & "Insert into Table1 (ID, Column1, Column2) values (5,
Coltext, ColText);" & vbcrlf
sSQL = sSQL & "Insert into Table1 (ID, Column1, Column2) values (6,
Coltext, ColText);" & vbcrlf
gRDODBms.Execute sSQL
Is it possible to execute the same syntax in Oracle? I don't know what the terminating string for Oracle would be.
Thanks in advance,
Tim McAteer
Received on Fri Dec 05 1997 - 00:00:00 CET