Devart Forums

I've C++ Builder 2010 and PgDAC bought yesterday.
I've done a project with a:
TPgConnection
TPgQuery
TDataSource
TDBGrid
TDBNavigator.

I've setted all the parameter and so I see all the record of a table into the DBGrid. At running time I modify a field of the table into the DBGrid, then with DBNavigator Post the modify but when I reopen the table there is always the same value. Why?
The problem is very simple, probably I've to set something, but what?

Hello

Record can be not saved to a database in the following cases:
1. If the AutoCommit property of TPgQuery (or TPgTable) is False and you don't call the Commit method of TPgConnection
2. If you set the CachedUpdates property of TPgQuery (or TPgTable) to True and don't call the ApplyUpdates method. If the AutoCommit property is False, then you should call the Commit method also.
3. Maybe your query is too complex and PgDAC cannot generate the update query automatically

Please provide us your query and DDL script for creating the tables that are used in your query.

I've sent the replay to [email protected] and [email protected]

I sent answer by E-mail.

I've found the problem in my application. There is a field, in my table, named 'user' that give me the error in the INSERT and UPDATE procedure.

Thanks for the Help
Fabio