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?



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



Regards



Adrian





[Non-text portions of this message have been removed]