SQL 92 dialect question:
HOW DO I SELECT FROM MULTIPLE FIELDS USING QUERY?
I AM USING VISUAL BASIC 6.0. I HAVE A PAGE WITH MSHFLEXGRID USING ADO. I HAVE
3 DROP DOWN BOXES LISTED AS QUERY 1,QUERY 2, AND QUERY 3. I NEED A RECORDSET THAT WILL SELECT FROM THE DATABASE, USING DIFFERNT FIELDS WITH VALUES TAHT CORRESPOND WITH THE DROP BOXES
EXAMPLE:
Dim strqueryr5 As String, queryr5 As String, query6 As String, QUERY7 As String, QUERY8 As String, QUERY9 As String
queryr5 = FILTER.DBCombo1.Text
query6 = FILTER.DBCombo3.Text
QUERY7 = FILTER.DBCombo2.Text
QUERY8 = FILTER.Text5.Text
QUERY9 = FILTER.Text6.Text
'strqueryr5 = "Select RECORDS.* From RECORDS Where (RECORDS.DRIVER = 'glenn') And (RECORDS.TRUCK = 'tandem' ) And (RECORDS.FUEL = 'diesel' )"
'strqueryr5 = "select * from records where fuel = " & """" & (queryr5) & """"
IT ONLY WORKS WHEN I TYPE IN THE SPECIFIC NAMES, BUT WOULD LIKE IT TO SELECT FROM THE DBCOMBO BOXES... IS THIS POSSIBLE???????
|