Forgive my ignorance Helen, would FB not delete the record based on its
primary key(which is not case sensitive, in this case, being an integer)?

Thanks,
Dion.


-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Friday, October 04, 2002 11:52 AM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Record not located to delete


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



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/