Is there an INSERT trigger on the table? If so, what does it do?

Hi, Tim -

Have you tested the PB application by enabling the database communications trace in PB, by prefacing the SQLCA.DBMS value with the word "TRACE" (e.g., SQLCA.DBMS = "TRACE MSO")?

There are additional database trace options as well. Open PB Help, navigate to the "Search" tab, and search for "pbtrace".

Best regards, John

commit

Hi Tim;

  Did your app...

• Check the Update() commands return code
• Have the DS/DC control "DBError" event coded
• Check the return code on the "Commit" command
• Verify that you're looking at the same DB instance

Regards ... Chris 

Hey Chris,

See my responses below

• Check the Update() commands return code 
  • ll_rv = dw_1.update using sqlca 
• Have the DS/DC control "DBError" event coded 
  • if ll_rv = 1 then
    messagebox("test","commit");
    COMMIT Using SQLCA;
• Check the return code on the "Commit" command
  • messagebox("test",string(SQLCA.SQLCode)); shows 0
• Verify that you're looking at the same DB instance
  • it is the same instance as it' s the only one we have

I agree with all of the below:

Be sure you have a commit (sounds like you do)

Check the return code of the update statement

Check the transaction.sqlcode
Check transaction.sqlerrtext also

Hello,

Here is the code snippet for update

In DBError event of dw_1

is_dberror = sqlsyntax
ib_dberror = True

Return 1

In Save button or save event

SQLCA.AutoCommit = False
ll_rc = Event ue_saveprocess_update()
If ll_rc = 1 Then
        SQLCA.commit
Else
	SQLCA.rollback
        // Display Error Process,
        // Error Message stored in variable ls_dberror
        Messagebox('Error', is_dberror)
End If
SQLCA.AutoCommit = True

Event ue_saveprocess_update

Long			ll_rc

ll_rc = dw_1.Update(True, False)
If (ll_rc <> 1 And ib_dberror = False) Then		// For dbError = True, Error captured at DBError Event which should not be overwritten here
        is_dberror = "Save Failed. Check DW update properties"
	Return ll_rc
ElseIf ib_dberror = True Then
	Return -1
End If

/* Added after Kim pointed out */
Return 1

IN the Save event, after rollback, messagebox will display, if there is any error that prevents the data being inserted.

HTH

Happiness Always
BKR Sivaprakash

There are two more options.

You insert and commit into

a.) another database.

b.) a table with the same name in another schema aka "user schema".

hth

Arnd