Web Development·12,052 discussions

Passing parameters from VB6 to SQL

Locked

Dim intVal as Integer
intval = 2020
qconn.Execute(“Select * from Table1 where userid=intval”)

The question is how can I make sql recognize or accept intval as a predefined variable in VB6 and run the query with resultset based on the value of intval?

Topic

Reply To: Passing parameters from VB6 to SQL

In reply to Passing parameters from VB6 to SQL

You need to ensure that the substitution takes place before the statement is executed.

“SELECT * FROM Table1 WHERE [UserID} =” & intval

Reply To: Passing parameters from VB6 to SQL

In reply to Reply To: Passing parameters from VB6 to SQL

Gave me the basic idea and was helpful.

Reply To: Passing parameters from VB6 to SQL

In reply to Passing parameters from VB6 to SQL

Dim intVal as Integer
intval = 2020
qconn.Execute(“Select * from Table1 where [userid]=” & CStr(intval))

As an alternative you could use a command object with parameters, but the above is the simplest to get the result you want.

Reply To: Passing parameters from VB6 to SQL

In reply to Reply To: Passing parameters from VB6 to SQL

The best answer so far and helped me to solve my problem. Thanks a million!

Reply To: Passing parameters from VB6 to SQL

In reply to Passing parameters from VB6 to SQL

This question was closed by the author

[Author]

Replies