Delphi FDQuery.SQL string starting with '!' dont work

Question

I have a query that is dynamically set up with a parameter. I query for lines with a varchar field that contains values that can begin with a '!'. But I get no match of those. I use SQLServer as the database server. If I take the sqlcode and run it directly in the database manager it works but not with TFDQuery. Se the code example below:

  myParameter := '!Tommy';
  with qryExec do
  begin
   SQL.Clear ;
   SQL.Add('SELECT * FROM myTable T WHERE T.Name='+quotedStr(myParameter));
   active := true ;
   first;
    if Not Eof then
    begin
      Result := True;
    end;
  end; //with

I have no idea what's wrong here, so I would be happy if anyone could come with an explanation.

You might have a look at docwiki.embarcadero.com/RADStudio/Sydney/en/… — MartynA
– MartynA, Commented Nov 26, 2021 at 19:28
May be a parameters pb, try ResourceOptions.ParamCreate := False — philnext
– philnext, Commented Nov 26, 2021 at 20:20
Thanks a lot, really fast answers :). I found that Andreas and MartynA answers is about the same. I haven't tried philnext:s solution, it would probably work but I love Brians solution below. It's really simple and nice. — larand
– larand, Commented Nov 27, 2021 at 8:40

Brian · Accepted Answer · 2021-11-27 02:17:10Z

1

I would suggest using actual parameters which also avoids the possibility of SQL injection. There are also overloaded versions of Open that reduce the housekeeping lines.

  FDQuery1.Open('SELECT * FROM myTable T WHERE T.Name= :NAME',['!Tommy'],[ftWideString]);

answered Nov 27, 2021 at 2:17

Brian

7,4702 gold badges30 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Delphi FDQuery.SQL string starting with '!' dont work

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related