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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to make query as variable

Status
Not open for further replies.
vkykumar

vkykumar

MIS
Feb 2, 2017
1
IN
Hi
I am using VB6 and an MS SQL Server database. I have combobox if i select tag's it fetch the data based on "Tagindex" in datadbase
instead of "0" in tagindex i want to pass based on tag selection value,
and this my Query "sql = "select DateAndTime,Val from FloatTable where DateAndTime ='" & SdateTime & "' and TagIndex =0""


some one help me for this problem .
 
Sort by date Sort by votes
VB6? You probably want to repost your question in forum222
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
difficult to crteate a query very complicated 1
Replies
9
Views
870
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
how to read the coordinates in from this file
Replies
3
Views
211
Ken01
Ken01
2009luca
  • Locked
  • Question
USE find instead to loop
Replies
2
Views
201
Andrzejek
Andrzejek
Niki_S
  • Locked
  • Question
How to merge two variables into one in VB 6? 1
2
Replies
22
Views
343
strongm
strongm
f0rg3tfu1
  • Locked
  • Question
circular reference caused by alias in query definition
Replies
7
Views
287
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top