Adrian wrote:

> Dear Jason (IBO 4.7beta4 FB2.0)
>
> I have been using a table named VERSION without problems for
> quite some time now.
>
> I distribute my software, with the version info contained in
> this table.
>
> The end user app then determines the version of the working
> DB, and compares to the distributed software, and then
> upgrades the database using scripts to the current version,
> this includes adapting data where necessary.
>
> After this step has successfully executed the Version
> info of the Version Table is also updated to reflect
> the latest version.... that is until now.
>
> Now the script executes successfully, only to fail on
> updating the data in the Version Query.
>
> IB_QueryVersion.Edit;
> IB_QueryVersion.FieldByName('VERSIONNUMBER').AsString := '8:3.3';
> IB_QueryVersion.FieldBy Name('VERSIONDATE').AsDate := '2006/11/23';
> IB_QueryVersion. Post;
>
> This now fails, and returns that the rows cannot be edited,
> whereas in the past it never was a problem.
>
> I was surprised, and then noticed that VERSION is in "" in
> the metadata in the software tool I use for managing my
> database.
>
> I asked on the firebird list, and it appears this is a
> reserved word, and thus placed in "" quotes.
>
> How is IBO parser dealing with this? IS the "VERSION" in
> quotes throwing it?
>
> I'm just guessing now?

Yes, I need to make sure when I am comparing identifiers that I am properly
taking quotes into account. This is still something I am knowing I need to
resolve. I am going to write a compare identifer routine and everywhere I
am comparing identifiers I am going to put logic to ensure quotes are
handled properly.

> PS.. Will you let me know when you have IB_Lookupcombo sorted out. ..
> passing the incorrect value when data posted.

I'll let you know when I resolve the lookup combo problem. It's on my list
of essential items to resolve.

Thanks,
Jason