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 example, in

[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