What can cause automatical commit while updating datawindow?

[anna123]

Hello:

I have datawindow built in runtime (PB 6.5) with the following update properties:

dw_1.Modify("DataWindow.Table.UpdateTable='" + Upper(as_table_name) + "'&quot

dw_1.Modify("DataWindow.Table.UpdateWhere='1'&quot
dw_1.Modify("DataWindow.Table.UpdateKeyInPlace=Yes&quot

FOR ll_index = 1 TO UpperBound(as_key_columns[])
dw_1.Modify(as_key_columns[ll_index] + ".Key=Yes&quot
NEXT

FOR ll_index = 1 TO ll_col_count
dw_1.Modify("#" + String(ll_index) + ".Update=Yes&quot
NEXT

After dw_1.Update(True, False) function, all the changes are already commited in the database. (Before I perform commit using SQLCA)!!!!!!

What can cause such automatical commit ?

Any help would be greatly appreciated.

Thanks in advance
Anna

 

[rt63]

There is as autocommit property of the default transaction object sqlca. Looks like in your case it is set to true. In your code set it to false

sqlca.autocommit = false
RT

 

[anna123]

Hi,

I performed transaction_obj.autocommit = false before
Update() and it didn't help. Maybe there is something in update properties of the datawindow?

Anna

 

[rt63]

Can you post the actual code (only the relevant part)? RT

 

[pjjohnson]

I would also have said Autocommit = FALSE.

What are you doing to check that data has been commited.

The only true test is to open SQLPLUS (or similar) and examine the data.

Only other way is if the table is a view and it is commiting data behind your back. IE. through an autonomous transaction on the instead trigger.

 

[PowerObject]

Hi,

Can you try putting the code:

<trans-object>.AutoCommit = FALSE ;


BEFORE you do the dw.SetTransObject( <trans-object> )? Or rather, BEFORE you do the:

CONNECT USING <trans-object> ;


typically somewhere in the Application object where the connection takes place.

Regards,

--
PowerObject!
-----------------------------------------

http://Groups.Yahoo.com/group/PowerObject

PowerBuilder / PFC Developers' Group