Page 1 of 1

Problem with UseQuoteChar parameter and TSQLStoredProc

Posted: Fri 27 Jun 2008 12:44
by 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.

Posted: Wed 02 Jul 2008 07:54
by 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;