Like in ADO query

[rewdee]

I am using ADOQuery component on a MS Access Database. The SQL is built on a search form. The Search form works correctly except when I use wildcards. I have displayed the SQL.Text on the web page and it looks like this:

============
SELECT * FROM Table1 WHERE Field1 Like 'ab*'
============

If I copy and paste into MS Access 2000, the query returns x number of records but in my ISAPI Dll none are returned.

The code to generate the SQL is

============
with qry do
begin
  ...
   SQL.Add('WHERE FrameNum Like ' + QuotedStr(sParam));
   ...
end;
============

Anyone see anything I'm doing wrong here?

Thanks,
Rewdee

 

[svanels]

I suspect that Ado understands the % wildcard.

I use:
SQL.Add('WHERE FrameNum Like :QuotedString');
ParamByName('QuotedString').AsString := MyString;

In your example MyString := 'ab%' for the matches beginning with ab or '%ab%' for the matches containing ab

Regards S. van Els
SAvanEls@cq-link.sr

 

[rewdee]

I think I do want to use the * wildcard (all records that begin with say ab). I believe you also misunderstand what my problem is. To generate the valid Access SQL statement

SELECT * FROM tbl1 WHERE Field1 Like 'ab*'

I use Delphi's QuotedStr function (to wrap my string in quotes). If I did not use the QuotedStr function it would be something like:

with qry do
begin
  ...
   SQL.Add('WHERE FrameNum Like ''''sParam'''');
   ...
end;

where sParam could equal something like ab*

Any other suggestions or hints I surely would appreciate it.

Thanks,
Rewdee