DLL Version: 1.10.0.7
Delphi 2010.
Driver Parameters:
SQLConnection.Params.Add('EnableBCD=True');
SQLConnection.Params.Add('UnpreparedExecute=True');
SQLConnection.Params.Add('UseQuoteChar=True');
SQLConnection.Params.Add('UseUnicode=True');
SQLConnection.Params.Add('DetectParamTypes=True');
QUERIES NOT QUOTED
Thank´s
UseQuoteChar problem
Query demo reserved word case sensitive
create table (name,"DESC");
select name,desc from table; <-- error
select name,"desc" from table; <-- error
select name,"DESC" from table; <-- OK
it´s Correct ?
thank´s
select name,desc from table; <-- error
select name,"desc" from table; <-- error
select name,"DESC" from table; <-- OK
it´s Correct ?
thank´s
The driver does not change queries that you write by yourself. If you set UseQuoteChar to True, quotes are added to the update statements that are generated when you call the ApplyUpdates method.
If you need to quote a reserved word, it is recommended to use lower case for PostgreSQL:
CREATE TABLE (name, "desc")
If you need to quote a reserved word, it is recommended to use lower case for PostgreSQL:
CREATE TABLE (name, "desc")