SQL Recipes (Beta II)
A FREE cookbook for SQL queries and examples
Register FAQ Search Today's Posts Mark Forums Read

SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it.

Go Back   SQL Recipes a FREE cookbook of SQL queries and examples > SQL queries and examples > SQL - Questions and Answers

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread
  #1 (permalink)  
Old 11-29-2006, 02:15 AM
RICHARD BAUMLER
 
Posts: n/a
Default 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???????
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Edit/Delete Message Reply With Quote
Be the first to answer this question! Click on the 'Post Reply' button below.
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Rate This Thread
Rate This Thread:

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Moderation Tools:


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to write select query for merging two columns? kajal SQL - Questions and Answers 1 03-13-2007 04:51 AM


All times are GMT. The time now is 07:44 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0
Copyright (c) 2006-2007 SQL Recipes

1 2 3 4 5 6 7