Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Visual Basic
Expertise: Beginner
Mar 16, 2000

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 Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap