Using Bind Variables in pass-thru query to Oracle DB.

  • Thread starter Thread starter chris
  • Start date Start date
C

chris

Can I use bind variables in a pass-thru query being sent to an Oracle DB?
How an I generate a prompt to the user? For example, how can I generate a
prompt for this?

SELECT * FROM Oracle_Table WHERE TABLEID=:table_ID_bind_variable
 
Can I use bind variables in a pass-thru query being sent to an Oracle DB? 
How an I generate a prompt to the user?  For example, how can I generate a
prompt for this?

SELECT * FROM Oracle_Table WHERE TABLEID=:table_ID_bind_variable
Click to expand...

build the SQL statement in a function, maybe.

Function oSQLStatement(byval lngtable_ID_bind_variable As Long)
oSQLStatement="SELECT * FROM Oracle_Table WHERE TABLEID=:" &
table_ID_bind_variable
End Function

Or

Function oSQLStatement() As String
Dim lngtable_ID_bind_variable As Long

lngtable_ID_bind_variable=InputBox("Please Enter a value")

oSQLStatement="SELECT * FROM Oracle_Table WHERE TABLEID=:" &
table_ID_bind_variable

End Function
 
Back
Top