dsaunders1971 wrote:

> I have tried this sort of syntax but just get a dynamic sql error
>
> SET TRANSACTION READ ONLY;
> select * from "Booking"

AFAIK, this is not available in DSQL.

> What's the full and proper format for this?

It depends on the library you use to access Firebird?

For example, in PHP it would be a parameter in ibase_prepare() function,
and in C++ using IBPP library, it would be a parameter in
TransactionFactory constructor.

What programming language / data access layer are you using?

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================