Pass Variables in SQL WHERE clause

alexisa · Dec 12, 1999

I need to be able to run a SQL query that will look something like this: 
SELECT * FROM

WHERE Field= (variable) 
That is pass a variable to the WHERE clause. 
assuming that I have a variable already present and that it holds the value of the a "field". 
What is the CORRECT SYNTAX? 
Any help will be great 
Thanks 
Alexis Alexis <a href=mailto:alexisale@msn.com>alexisale@msn.com</a> <a href= > </a>

calahans · Dec 13, 1999

Hi alexisa, 
 
Below is a sample code: 
 
Dim strWhere as string 
Dim strSQL as string 
 
strWhere = text1.text 'Take in criteria from text box 
 
strSQL = "SELECT * FROM

WHERE Field=" 
strSQL = strSQL & strWhere 
 
............ 
 
 
Obviuosly you need to open a connection to a database and bring back a recordset. If you are not sure how to do this let me know and I'll post the code. 
 
HTH 
 
C

VB400 · Dec 13, 1999

I believe that the syntax is different for string vs. numeric fields (possibly dependent on the database). 
 
For numeric fields: 
"Select * From ..... Where myFld = " & NumericField 
 
For string fields: 
"Select * From ..... Where myFld = '" & StringField & "'" 
where you're surrounding your data with single quotes. 
 
For date fields (and Access): 
"Select * From ..... Where myFld = #" & DateField & "#"

calahans · Dec 14, 1999

VB400 is correct, you do need the double quotes around the string. However, the # sign is not needed for dates (outside of access) 
 
C

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Pass Variables in SQL WHERE clause

alexisa

MIS

calahans

Programmer

VB400

Programmer

calahans

Programmer

Similar threads

Part and Inventory Search

Sponsor