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 ==================================