>>For readonly there was no problem here either - it's when they're all updatable and have sent some updates to the server.
>>The scenario I have is that one CA creates the record, the next bizobject adds a few records into a child table and then writes the FK to it into the 2nd CA on the same table as the first one. Then a third CA on the same table is fired and just retrieves the same record. At that point, it misbehaves. Mostly (depending on what I do) it thinks that it got a record inserted into the cursor (even though that record is retrieved from the server) and does an automatic tableupdate() which generates an insert statement being sent to the SQL right away.
>>
>>I got it to work correctly by using .cursorFill() with a new statement. Will need some time to try Fabio's trick with .cursorRefresh(lcModifiedSelectCommand).
>
>Backend you were working against? .WhereType you are using ? Which PK-Type and (depending on previous answers) how created ?
SQL /(20005 and 2014, possibly 2008r2 as well), pk only, int, created manually (i.e. calling a server-side function independently, before tableupdate).