Hi Norman, > You can use various SHOW commands in isql to query database metatdata. > Metatdata is stored in system tables. When a SHOW command is issued, > isql commits the current transaction and begins a new one, in READ > COMMITTED isolation.
As you showed below, this is not (always) true. Maybe it only commits DDL? Personally, I would't like SHOW to commit anything at all! I expect SHOW to SHOW me something, not to CHANGE anything! > Are there any specific SHOW commands which cause any DML transactions to > be committed or is the original statement about a commit being executed, > completely false? Sorry, I've got no idea. But with Dmitry on the list... :-) Cheers, Paul Vinkenoog BTW: 'metatdata'? (twice) ------------------------------------------------------------------------------ AppSumo Presents a FREE Video for the SourceForge Community by Eric Ries, the creator of the Lean Startup Methodology on "Lean Startup Secrets Revealed." This video shows you how to validate your ideas, optimize your ideas and identify your business strategy. http://p.sf.net/sfu/appsumosfdev2dev _______________________________________________ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs