Re: Non-skipping IDs with Master-Detail


>Also, the order number (master ID) CANNOT SKIP, so from what I
>read, I'm only supposed to set the next key right before
>UpdateBatch to minimize conflicts in a multi-user environment.
>
>I issue a BeginTransaction right before calling my GetNextKey
>function (which also increments the key). This way, if the user
>aborts the order, everything gets rolled back at once.

There is not much worse that you can do to create problems on an SQL server than
to leave transactions open while a user has control of your application.
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: HELP! Subscription obsolete and Data NOT sychronized!
    ... If the updates are partitioned, then you can use this tool more ... conflicts, or in other words, which node is the master. ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: [GIT pull] x86 fixes for 2.6.26
    ... So rebasing is fine as long as it's clear that it's ... 'master' much earlier before the topic becomes ready to be merged to ... uncooked topics, if they have conflicts with 'master' or 'next', I'd ... advance 'master' with obviously good patches, ...
    (Linux-Kernel)
  • Re: UpdateBatch or Post changes state to dsBrowse
    ... problem regarding Master-Detail keys. ... I'm using a detail datasource that is linked to the master ... UpdateBatch everything after the user clicks the apply button. ... >If you are not using batchupdates you will get the database errors returned on ...
    (borland.public.delphi.database.ado)
  • Non-skipping order numbers and Master-Detail links
    ... order after all master and detail information has been entered. ... I issue a BeginTransaction right before calling my GetNextKey ... UpdateBatch) on the DETAIL table, the record just disappears, ... as if the foreign key was not set. ...
    (comp.lang.pascal.delphi.databases)
  • Non-skipping IDs with Master-Detail
    ... order after all master and detail information has been entered. ... UpdateBatch to minimize conflicts in a multi-user environment. ... I issue a BeginTransaction right before calling my GetNextKey ... for Master-detail link and create a separate OrderNumber field, ...
    (borland.public.delphi.database.ado)