devxlogo

Using Variables in SQL

Using Variables in SQL

Question:
I have connected a form to the DB using an ADODC. I connect fine, I can read the DB if I put a literal in my sql:

recordsource = select * from table1 where employeenum = 108

But, I want to use the value that is stored in the employee text box.

recordsource = select * from table1 where employeenum = form2.candidatenum.text

I get the message, “No value given for one of more required parameters”.

Answer:
You have to concatenate the text box value to your SQL statement, like so:

recordsource = "select * from table1 where employeenum = " & form2.candidatenum.text

devx-admin

Share the Post: