Devart Forums

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

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

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")