Expand my Community achievements bar.

How to create a button with dynamic SQL Query

Avatar

Former Community Member
Hi,

I have a text field and I want to set the value that is entered as the where statement of a SQL Query. The Database Connection (access; odbc) is no problem.



Could someone give me a code sample for a dynamic SQL Query, which gets the "where" from a text field and gives the values of a second column to a drop down list or list box.



The value that is entered in the Text field is no primary key.



Regards, Holger
1 Reply