Re: find max id for forms
From: Matt B. <gtimatt_at_home.com>
Date: Wed, 08 Aug 2001 01:53:49 GMT
Message-ID: <NY0c7.41042$MC1.12184130_at_news1.elcjn1.sdca.home.com>
Date: Wed, 08 Aug 2001 01:53:49 GMT
Message-ID: <NY0c7.41042$MC1.12184130_at_news1.elcjn1.sdca.home.com>
"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message
news:3B702BBE.352C_at_yahoo.com...
>This only works in a single-user system, since two or more people could get
the same value.
It depends on when you do it. If you do it on WHEN-NEW-RECORD-INSTANCE or WHEN-VALIDATE-RECORD, maybe. If you do it on PRE-INSERT, less likely.
>A sequence is a better solution
Again, depends on when you do it. On PRE-INSERT, most likely OK. If you assign it sooner and the user doesn't commit, you'll "waste" the uncommitted ones.
-Matt Received on Wed Aug 08 2001 - 03:53:49 CEST