Subject Firebird 2.1: Statement failed, SQLCODE = -902
Author Nando
Hi to all.

Linux CentOS 5.8 box with Firebird 2.1 clasic:

When I run a "SELECT * FROM my_table", this returns records ok, but if I execute "SELECT * FROM my_table ORDER BY my_date_field" returns the following error:

Statement failed, SQLCODE = -902
operating system directive open failed
-No such file or directory

I can't find how to fix this.

Any help will be appreciated.

Hernando.