Hi Cesar;

   I suspect that the issue is between the actual Table Structure and how the DWO's Update Properties are being set. You would need to give us a lot more information, such as:

• DBMS type & version.
• PB version & build
• DB Client software used to connect to your DBMS.
• Table Schema definition (ie: as per the DB Painter)
• DWO source (update properties)
• List of any Triggers on the Table
• etc.

Regards ... Chris

Hi

dw_XX.Update() without parameter does an AcceptText() and a ResetUpdate():

integer dwcontrol.Update ( { boolean accept {, boolean resetflag } } )

So you reset the update flags and rollback. The 2nd update does an update instead of an insert.

So it would be  dwcontrol.Update ( TRUE, FALSE)

and do a ResetUpdate() if OK.

Regards
Arthur

Here is a sample code to update dw

String		ls_msg
Long		ll_rc

ib_dberror = True // instance variable, value set in dw_1's dberror event to false

SQLCA.autocommit = False

ll_rc = dw_1.Update(True, False)

If ll_rc = 1 and ib_dberror = True Then							
	Commit;
	dw_1.ResetUpdate()
Else
        ls_msg = SQLCA.Sqlerrtext
	Rollback;
	MessageBox('Save Failed', ls_msg)
End If
SQLCA.autocommit= True

HTH

Happiness Always
BKR Sivaprakash