I'm not sure what the problem could be.
Those statements look like I think they should.
Please get IBO 4.2 F and let me know if it behaves this way still.
I did make a change to tidy that part of the code and make the OLD case
insensitive.

Thanks,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <angerp@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, October 29, 2001 3:21 AM
Subject: [IBO] IBOQuery and FireBird 1.0.0.388 Beta 2


> I'm working with d6 ibo 4.2.Eg and FireBird 1.0.0.388 Beta 2 dialect
> 3.
>
> I put an TIboquery object into a Form and I click in sqlEditor's
> Property to
> prepare the select statement like this
>
> SELECT "codice"
> , "descrizione1"
> , "descrizione2"
> , "via"
> , "cap"
> , "citta"
> , "provincia"
> FROM "dit"
>
>
> I must generate the insert,update, delete statement from tab update
> sql .
>
> when I try to view the data I except this error
>
> invalid custom reference :"OLD_codice"
> update statement
>
> what's meaning ??????
>
> paolo angeretti
>
> -------------------------------
> update statement
> -------------------------------
> UPDATE "dit" SET
> "descrizione1" = :"descrizione1",
> "descrizione2" = :"descrizione2",
> "via" = :"via",
> "cap" = :"cap",
> "citta" = :"citta",
> "provincia" = :"provincia"
> WHERE
> "codice" = :"OLD_codice"
>
> -------------------------------
> insert statement
> -------------------------------
> INSERT INTO "dit"(
> "codice", /*PK*/
> "descrizione1",
> "descrizione2",
> "via",
> "cap",
> "citta",
> "provincia")
> VALUES (
> :"codice",
> :"descrizione1",
> :"descrizione2",
> :"via",
> :"cap",
> :"citta",
> :"provincia")
>
> -------------------------------
> delete statement
> -------------------------------
> DELETE FROM "dit"
> WHERE
> "codice" = :"OLD_codice"