>Hi Helen
>
>Thanks. I understand the issues and agree that generally reserved words should be avoided like the plague. The only fields that are quoted in
>our DB are reserved words that were defined before the database was a Firebird database !
>
>All our SQL is correct and working, the database version has not changed, the issue is with IBO. Previously (IBO 4.8) code like
>
>Query.FieldByName('Rows').AsInteger
>
>worked perfectly. Now this code returns a 'Field not found' exception (IBO 5.2). This is obviously a code change between IBO versions and I
>was hoping that Jason would be able to help me out with this.

But is the field defined as "Rows" or "ROWS" in Firebird? I would assume Query.FieldByName('Rows').AsInteger to match "ROWS", to make it match "Rows", I'd assume you'd have to change to Query.FieldByName('"Rows"').AsInteger.

Set