> Which driver are you using. My guess is that you are using the MS Oracle driver. Compared to the native Oracle driver, it falls far short of what you can do.
Oracle92 drivers
> Short of using sql loader - or using command line operations to run a sql script - which would be outside of ODBC - I am not sure you can render multiple lines.
While I have a VFP PRG to create the SQL Loader files, this is for a demo at SouthwestFox and I was only going to try inserting 2 records. 1 at a time is no big deal.
> Of course, stored procs is the way to go - but given your limitations, I know that this is likely not feasible for you....
As for where I currently work, we are started to make some head way through the Berlin Wall otherwise known as our IT staff. On my current project, I am making enormous use of SPs. Slicker than S... through a goose.
Mark McCasland
Midlothian, TX USA