开发者

How to escape special characters in SQL strings from Delphi?

开发者 https://www.devze.com 2022-12-18 04:09 出处:网络
How to escape the special characters when executing an SQL query, when it is executed from Delphi using TADOQuery or TADOCommand etc..

How to escape the special characters when executing an SQL query, when it is executed from Delphi using TADOQuery or TADOCommand etc..

For examp开发者_开发技巧le the "scope operator".

Query looks like this.

GRANT CONTROL ON SCHEMA :: dbo TO supervisor

Thanks & Regards, Pavan.


I do not work with Delphi for a while, so far I remember a few tricks:

  1. Set ParamCheck = False;
  2. Run queries with connection.Execute(SQL);
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号