Problem with UseQuoteChar parameter and TSQLStoredProc

[Robert Haraszti]

I use Delphi 2005, and the newest dbExpress driver.
My problem, when I turn on the UseQuoteChar property, the TSQLStoredProc component send the procedure name in double Quote.

e.g.

'"procedure_name"'

I must disconnect, change param, connect again to solve this problem.

[Plash]

You can change UseQuoteChar option without disconnect. Use a code like the following:

Code: Select all

const
  coUseQuoteChar = TSQLConnectionOption(202);
begin
  SQLConnection1.SQLConnection.SetOption(coUseQuoteChar, Integer(False));
end;