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:
- Set ParamCheck = False;
- Run queries with connection.Execute(SQL);
精彩评论