Sorry, but I don't understand your problem.

Why do you want to check if A.Code is references somewhere, due to the fact
that you are changing GroupCode???

Thomas

> -----Original Message-----
> From: Flipado [mailto:arsoft@...]
> Sent: Thursday, July 12, 2001 8:34 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Not IBO related, but IB related
>
>
>
> I hope some of you can help me on this. I have post it on mers, but
> no luck :(.
>
> This is the problem:
>
> (cut & Paste from my post in Mers)
>
> I have a problem that I don't know how to solve. I need to pick the
> info on
> a trigger is the register that I'm updating is referenced elsewhere.
> I will
> try to explain myself:
>
> TABLE A:
> Code PK
> GroupCode
>
> TABLE B,C,D,....
> SomeField REFERENCES TABLEA.Code
>
> What I need to know is there any reference to TABLE A.CODE in any of
> the
> other tables, so I can change safely the value of GroupCode.
>
> Is there any place in interbase that 'Counts' the number of
> references that
> I can use on a table?
>
> Thanks to All
> (and sorry about my english)
> (and sorry again for my off-topic message.
> I use this list every day because I'm a (two-months) newbie to IB &
> IBO : I'm a listener to the for now, but I hope I can help in a few
> months)
>
> Artur Anjos
>
>
>
>
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>