Re: Preventing Duplicates in BeforePost event.
- From: "Chris Cooper" <cooperc@xxxxxxxxxxx>
- Date: Wed, 20 Jul 2005 11:05:29 -0600
The TADODataSet(DataSet).RecordStatus will aways be rsNew untill the
UpdateBatch is executed. Sorry to be a pain, but using my code can you give
me an example of what you mean?
"Brian Bushay TeamB" <BBushay@xxxxxxxxx> wrote in message
news:704rd1993hf8j3jjojl8tqqp6pnou3go4u@xxxxxxxxxx
>This worked great while the user was entering the values. However, if at a
>later time in the code a record had to be modified, the BeforePost event
>would fire and then I would get the message about a dupicate record. This
>is because the cloned dataset now had all entered record and whenever the
>BeforePost event fires it aready has the values.
You should be able to check the STATUS property. If it is dsInsert use
your
code and if it is DSUpdate you need to check for more than one record with
your
key value
>
>Does anyone else know of a better way to prevent duplicates?
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.
- References:
- Preventing Duplicates in BeforePost event.
- From: Chris Cooper
- Re: Preventing Duplicates in BeforePost event.
- From: Brian Bushay TeamB
- Preventing Duplicates in BeforePost event.
- Prev by Date: Problems with multiple recordsets when calling sp_help
- Next by Date: Re: Preventing Duplicates in BeforePost event.
- Previous by thread: Re: Preventing Duplicates in BeforePost event.
- Next by thread: Re: Preventing Duplicates in BeforePost event.
- Index(es):
Relevant Pages
|
