In order to run the SELECT statement, it still needs to start a transaction.

if you wish to build a read-only database to place on some read-only media like CD or DVD ROM. you can do it with:
gfix -mode read _only database. fdb
.....or within your favorite administration tool. ft is also AVAILABLE VIA ServicesAPl, so you may do it from your application as well. PLEASE note that you can only make this CHANGE while preparing the database, because the read-only flag needs to be written in the database FILE.

When the database becomes read-only, the only thing you can write to is the read_only flag (to reset it back to read-write).

In order to run the SELECT statement, it still needs to start a transaction.

if you wish to build a read-only database to place on some read-only media like CD or DVD ROM. you can do it with:
gfix -mode read _only database. fdb
.....or within your favorite administration tool. ft is also available via ServicesAPl, so you may do it from your application as well. Please note that you can only make this change while preparing the database, because the read-only flag needs to be written in the database file.

When the database becomes read-only, the only thing you can write to is the read_only flag (to reset it back to read-write).