-
Having a problem
Hey so this is part of an assignment which I have no idea what to do with it...can anyone explain it to me in english that I understand....Thanks
One subform should allow selection (using an SQL query) of any attribute (field) from a table of your choice with any value (i.e SQL query with variable WHERE clause values) from ONE table with the result displayed to a datagrid. This will require a choice of the attribute from a list, the operation (=, > , < etc) cloasen from a list and the attribute value entered.
-
Re: Having a problem
Thread moved to Database Development forum (the "VB6" forum is meant for questions which don't fit in more specific forums)
You are being asked to build a string containing an SQL statement, using the fieldname/operator/value that the user selected.
The format of the SQL statement (when built) will be something like this:
"SELECT * FROM tablename WHERE fieldname = value"
You may find it useful to take a look at the articles in the SQL section of our Database Development FAQs/Tutorials (at the top of this forum)