Use of SQL parameters via ODBC drivers

  • Thread starter Thread starter JB
  • Start date Start date
J

JB

Hi All,

I run simple insert statements [e.g. INSERT INTO Table1 (Col1, Col2)
VALUES ('V1', 'V2')] many times on many different databases.
At the moment, I'm building each statement dynamically every time, and
I'd like to use SQL parameters instead. I'm wondering if and how it's
possible to use SQL parameters via ODBC driver in the same way for all
target databases (e.g. SQL Server, Oracle, Access, etc)

Thanks
JB
 
Hi All,

I run simple insert statements [e.g. INSERT INTO Table1 (Col1, Col2)
VALUES ('V1', 'V2')] many times on many different databases.
At the moment, I'm building each statement dynamically every time, and
I'd like to use SQL parameters instead. I'm wondering if and how it's
possible to use SQL parameters via ODBC driver in the same way for all
target databases (e.g. SQL Server, Oracle, Access, etc)

Thanks
JB
Click to expand...

Yes it will. Or should work. The important thing is that the right
provider and connection properties are alright.
 
Hi All,

I run simple insert statements [e.g. INSERT INTO Table1 (Col1, Col2)
VALUES ('V1', 'V2')] many times on many different databases.
At the moment, I'm building each statement dynamically every time, and
I'd like to use SQL parameters instead.  I'm wondering if and how it's
possible to use SQL parameters via ODBC driver in the same way for all
target databases (e.g. SQL Server, Oracle, Access, etc)
Click to expand...

An ODBCCommand object does support Parameters, but the syntax in the
select statement is different. Instead of naming the parameters, you
use the question mark ("?") as a placeholder for the parameter.
 
Back
Top