At 12:54 PM 04-10-02 +0200, you wrote:

>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)?

The IDENTIFIER is case-sensitive. So your KeyLinks will have to be

FUNDID
or
"FUNDID"

not
FundId

Helen

>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/
>
>
>
>
>
>
>
>___________________________________________________________________________
>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/