[firebird-support] How can you change the transaction level to READ_ONLY in SQL

2011-10-28 Thread dsaunders1971
Hello, I have tried this sort of syntax but just get a dynamic sql error SET TRANSACTION READ ONLY; select * from "Booking" What's the full and proper format for this? Thanks in advance

Re: [firebird-support] How can you change the transaction level to READ_ONLY in SQL

2011-10-31 Thread Milan Babuskov
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 exampl