Oracle and VB 4.0

From: Tim <tim.mcateer_at_hie.com>
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

Original text of this message