J
John Øllgård Jensen
I have got a adp frontend search form and SQL Server backend database.
The search criterias are set up in the header section (unbound text
fields and comboboxes) - each corresponding a field in the record to be
searched + one unbound text for global.
Pressing a search button, a SELECT statement ( SELECT Field1 and
Field2 and Field3 FROM MyTable) is created in the code behind - and the
statement is executed by SQL Server.
(Note % is omitted in the statement for simplicity)
This is working, but how am I making a global search (searching all
fields). Concatenating the text fields could be a solution, but this is
not working when the data type is ntext.
Help preciated
John
The search criterias are set up in the header section (unbound text
fields and comboboxes) - each corresponding a field in the record to be
searched + one unbound text for global.
Pressing a search button, a SELECT statement ( SELECT Field1 and
Field2 and Field3 FROM MyTable) is created in the code behind - and the
statement is executed by SQL Server.
(Note % is omitted in the statement for simplicity)
This is working, but how am I making a global search (searching all
fields). Concatenating the text fields could be a solution, but this is
not working when the data type is ntext.
Help preciated
John