At 11:27 AM 04-10-02 +0200, you wrote:

>Hi,
>
>My Meta data:-
>
>There are two entries :-
>
> FundId FundName UnderWriterId
> ------ -------- -------------
> 4 FUND 1 10
> 5 FUND 2 12
>
>
>CREATE TABLE "FUND"
>(
> "FUNDID" INTEGER NOT NULL,
> "FUNDNAME" VARCHAR(50) NOT NULL,
> "UNDERWRITERID" INTEGER NOT NULL,
>CONSTRAINT "FUND_PK" PRIMARY KEY ("FUNDID"),
>CONSTRAINT "FUND_UN" UNIQUE ("FUNDNAME")
>);
>
>ALTER TABLE "FUND" ADD FOREIGN KEY ("UNDERWRITERID") REFERENCES
>"UNDERWRITER" ("UNDERWRITERID");
>SET TERM ^ ;
>
>
>/* Triggers only will work for SQL triggers */
>
>CREATE TRIGGER "FUND_KEY" FOR "FUND"
>ACTIVE BEFORE INSERT POSITION 0
>AS BEGIN
> IF ((NEW.FUNDID = 0) OR (NEW.FUNDID IS NULL)) THEN
> NEW.FUNDID = GEN_ID(FUND_GEN, 1);
> END
> ^
>
>I expected to receive a "Cannot delete due to referential constraints" or
>something similar ...
>I have tried a using new(from palette, not copied) TIB_Query and TIB_Grid
>components, but to no avail.

It looks to me as if your problem is case-sensitive identifiers. You will
either need to
-- use double-quotes and correct case for everything you created; or
-- use upper-case only for everything you created in double-quotes with
uppercase identifiers

..as applicable..

Helen