Dynamic query..?

[kenjoswe]

Hi all,

How can I retrive records in VB6 using a value from a TextBox into a SQL-query?

Something like:
select * from Table1 where Field1= TextBox1

/Kent J.

 

[csjoseph]

Yes, you are on the right track. just make sure you concatenate correctly. Below is an example of how to concatenate your sql string.

"SELECT * FROM DB.dbo.TABLE_NAME WHERE User_name = '" & text1.text & "'"

 

[MatsHulten]

"select * from Table1 where Field1 = " & texbox1.text

-Mats