Problem with UseQuoteChar parameter and TSQLStoredProc

Problem with UseQuoteChar parameter and TSQLStoredProc

Postby Robert Haraszti » Fri 27 Jun 2008 12:44

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.
Robert Haraszti
 
Posts: 1
Joined: Mon 23 Jun 2008 11:20

Postby Plash » Wed 02 Jul 2008 07:54

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;
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09


Return to dbExpress driver for InterBase & Firebird