cwtang
asked on
How to rephase statement for use in SQL from MS Access in Delphi
I have a statement that is being used for MS Access in Delphi. However, as I need to upgrade the database to SQL, I am not sure how to reconstruct the statement. The statement that is being used for MS Access is:
SQL.Add('Select * From table1, table2 Where field1 Like ' + ' "' + Text1.text + '*' + '" ');
The statement run when a entry is entered into the text box and it will look up the SQL database and show only the refined results.
Any help is appreciated.
Ā
SQL.Add('Select * From table1, table2 Where field1 Like ' + ' "' + Text1.text + '*' + '" ');
The statement run when a entry is entered into the text box and it will look up the SQL database and show only the refined results.
Any help is appreciated.
Ā
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER