Hi, Rachid -

Run a database trace from your app (preface the SQLCA.DBMS property value with the word "TRACE", such as SQLCA.DBMS = "ODB" becomes SQLCA.DBMS = "TRACE ODB", for example).

Examine the contents of the trace file to see what it tells you.

Another idea is to open the DataWindow data object in the DW Painter, insert a row in the Preview pane and manually populate the row with the same values as what is being attempted in the application, then save the new row via Rows -> Update menu item. You should be sure your PB Database Profile uses the same settings as your application.

Best regards, John

I'm using PostgreSQL and do not have that issue.

Please post your code so we can see what is occurring. Also, please checj the STATE of the row prior ro issuing the UPDATE.


dwitemstatus    ldw_itemstatus

ll_row                 = dw_1.GetRow ()
ldw_itemstatus = dw_1.GetItemStatus (ll_row, 0, Primary!)

IF (ldw_itemstatus = NewModified! OR ldw_itemstatus = DataModified!) THEN

   ll_rc = dw_1.Update (TRUE, TRUE)

END IF

Hi Rachid;

   Please make sure that your App...

1. You App code checks the return code of the Update() command for "success".
2. The DW Control or DataStore has the DBError event coded to trap any DML processing issues.
3. The DW Control or DataStore has the Error event coded to trap any column value assignment issues.

Regards ... Chris

Hi,

So if I understand well, you do a COMMIT, but changes are not being commited.

What about your connexion parameters for SQLCA?

Is autocommit ON or OFF?

regards

Rachid,

Ensure whether
1.  The Table got any constraint that makes the data to rollback
2.  Check for any dbErrors in DBError event
3.  Try inserting the same row with same values from PGAdmin and see any error gets displayed.
4.  Finally, ensure that you are checking the same database, same server where PB is inserting the row.  [ It happens to me, since we connect to PG via IP address ]

HTH

Happiness Always
BKR Sivaprakash

AUTOCOMMIT is OFF

Here is a screenshot that may be will help. You can see that idw_operation contains one row