Jens Andersen
|
| Posted: 10/15/2004, 3:12 PM |
|
Hi,
having an multiple key table that im using in an editable grid. i need to make a check so that the key is not violated before updating and inserting. does anyone have examples on how this is done.
regards
Jens Andersen
|
|
|
 |
DonB
|
| Posted: 10/16/2004, 7:32 AM |
|
I'd think you would want to let the database deal with it in it's insert or
update, then check the error that is returned. You can check the Errors
collection (array) and substitute your own (more friendly) error message.
Do this in the After Insert and/or After Update events.
--
DonB
http://www.gotodon.com/ccbth
<JensAndersen@forum.codecharge (Jens Andersen)> wrote in message
news:541704b36bc8c4@news.codecharge.com...
> Hi,
>
> having an multiple key table that im using in an editable grid. i need to
make
> a check so that the key is not violated before updating and inserting.
does
> anyone have examples on how this is done.
>
> regards
> Jens Andersen
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Jens Andersen
|
| Posted: 10/19/2004, 1:36 AM |
|
thx for your answer,
as opposed to sql server or access mysql doesnt return an error message to codecharge - the db sends its own page with a halt warning. is this error readable in the after insert error array ?
any suggestions ?
regards
Jens
|
|
|
|
|
