Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: [SOLVED] can not save a new record (syntax error)



Permlink Replies: 1 - Last Post: Jun 30, 2017 1:27 AM Last Post By: Dmitry Vavilov
Dmitry Vavilov

Posts: 21
Registered: 2/22/15
[SOLVED] can not save a new record (syntax error)
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jun 23, 2017 8:12 AM
Hi!
It is not possible to save a new record from the ClientDataSet, because in the inserted query the field names are enclosed in "[]". PostgreSQL does not allow the declaration of field names in "[]".
The problem in the procedure is Datasnap.Provider.TSQLResolver.GenInsertSQL.
How can I solve the problem?

Edited by: Dmitry Vavilov on Jun 30, 2017 1:27 AM
Dmitry Vavilov

Posts: 21
Registered: 2/22/15
Re: [CDS+FireDAC+PostgreSQL] can not save a new record (syntax error)
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jun 23, 2017 8:34 AM   in response to: Dmitry Vavilov in response to: Dmitry Vavilov
The problem is solved.
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02