New Rows not saved to database?

[NewLink168]

Hi all,
we have a problem updating datawindows here.
after new rows being added to a datawindow, a GetFullState
function is called to transfer the datawindows object to
another function to perform Update. the problem is sometimes
new rows are not identified and Insert statements are not
created for those rows (from tracing SQL statements for the
update). the symptom is after the update and date is
retrievd back from the database, rows disappear from the
datawindow.

platform: PB 11.2, SQL Server 2005 Native Client Driver.
Windows XP SP2

any ideas?

 

[mbalent]

Are you calling setchanges on the datawindow prior to the save logic?

Matt

"Nature forges everything on the anvil of time

 

[NewLink168]

yes - when GetChanges is called.
SetFullState is called when GetFullState is called.

btw, this function worked fine with PB8, SQL 2000, XP SP2 environment.

 

[mbalent]

If you point the PB11.5 to SQL 2000 does it work?

Matt

"Nature forges everything on the anvil of time

 

[NewLink168]

never tried using PB11.2 with sql 2000.
sql 2000 no longer exists in our environment - problem discovered after implementation of production.

it is probably related to the client side of things. the buffer status seems to be messed up with the new drivers - PB 11.2 driver, SQL Native Client driver etc.