Re: insert one at a time

You could put a call to COMMIT_FORM in all KEY triggers that will cause navigation from the current record.

Also (and I might be getting this wrong because it's been a couple of years) there is an odd ON trigger that can have restricted builtin in it whcih might help. Might be ON_NEW_ITEM_INSTANCE though so might not be that much use.

Alternatively. Disable keys that nafvigate to other records (awkward if you have mnore than one block) and define KEY_COMMIT to clear the block after committing it so you can only ever access a single record.

However, I would ask, what business rule do you have for only committing a single record? If we could understand the reasos a bit better we perhaps could give a better solution.

Alan

"Daud" <daud11_at_hotmail.com> wrote in message news:f0bf3cc3.0210272035.30c23c8d_at_posting.google.com...
> Hmm maybe I am not getting it.....just how do you do that?
>
> "justme" <paulq_at_rogers.com> wrote in message
news:<9ZYu9.79113$mxk1.35851_at_news04.bloor.is.net.cable.rogers.com>...
> > sure , do a commit in the form before navigating to another record.
> >
> > "Daud" <daud11_at_hotmail.com> wrote in message
> > news:f0bf3cc3.0210270125.50b7323b_at_posting.google.com...
> > > Hi All
> > >
> > > Is it possible to create a form that will only allow user to insert
> > > one record at a time. What I mean is that whenever a record is
> > > inserted, it has to be saved first before the next one can be
> > > inserted. Some goes for update.
> > >
> > > Thanks.
> > >
> > > rgds
> > > Daud
Received on Mon Oct 28 2002 - 10:34:40 CET