Transaction is tiCommited, AutomCommit is false
Detqail query's Masterlink is
mass_detail.id=masspay.id
both ID fields are generated by GeneratorLinks
id=mass_gen


I normaly works OK - I can insert records and go back and edit them without
problems


Riho-Rene Ellermaa
senior programmer
Hansabank

Sure; but it's a fact of life that you can't update a row that doesn't
exist. An insert is one statement, an update is another - separate
statements. If you want to keep all mixed mode work on a particular
master/detail group inside one transaction so that all will commit and be
saved or all will roll back and be cancelled together, you might look at
using a stored procedure call (same procedure) on the EditSQL and InsertSQL
of the detail set to achieve it. Pass all the columns to the SP as
parameters and have the SP check for the existence of the row before
deciding whether to insert or update...

What mechanism are you using to form the master-detail relationship?

-- helen






[Non-text portions of this message have been removed]