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?
How can I modify a table in a Postgres db?
-
- Posts: 14
- Joined: Mon 21 Jun 2010 13:55
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.
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.
-
- Posts: 14
- Joined: Mon 21 Jun 2010 13:55
I've sent the replay to [email protected] and [email protected]
-
- Posts: 14
- Joined: Mon 21 Jun 2010 13:55