Article View: borland.public.interbase.sql
Article #11379Re: Anyone could correct this for me "set transaction name "tran1" read write committed;" Thank you
From: NEWBIES
Date: Mon, 25 Nov 2002 17:59
Date: Mon, 25 Nov 2002 17:59
36 lines
2491 bytes
2491 bytes
Hi Craig, I read from SQL reference (extracted InterBase Documentation Beta): "Starts a transaction and optionally specifies its behavior. Available in SQL, DSQL, and isql." Is that fool me again...........which should I refer to as to know what support what if the only documentation extracted seems convey faulty information (may be I interpret it wrongly).............. Any good SQL reference you have in hand, if mind is the most updated, or just out, I am currently using 6.0.2 already(has just switched to 6.0.1).............................................I remember you say in somewhere that the old version is buggy.... Thank you. "Craig Stuntz [TeamB]" <cstuntz@nospamplease.com (but use vertexsoftware to email)> ���g��l��s�D:MPG.184c12ae2a6c1ab098a256@newsgroups.borland.com... > In article <3de2187e$1@newsgroups.borland.com>, newbies@netvigator.com > says... > > "set transaction name "tran1" read write committed;" > > "commit;" > > > > What's wrong with above statement, interactive SQL don't accept; > > > It isn't supported in ISQL. > > -Craig > > -- > Craig Stuntz [TeamB] ?Vertex Systems Corp. ?Columbus, OH > Delphi/InterBase Weblog : http://delphi.weblogs.com > InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor > InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer
Technical Details
Message-ID:
<3de264f9$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3de2187e$1@newsgroups.borland.com> <MPG.184c12ae2a6c1ab098a256@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 114a0e,da4c526e733a5665 X-Google-Attributes: gid114a0e,public X-Google-ArrivalTime: 2002-11-25 10:09:53 PST Reply-To: "NEWBIES" <NEWBIES@netvigator.com> From: "NEWBIES" <NEWBIES@netvigator.com> Newsgroups: borland.public.interbase.sql References: <3de2187e$1@newsgroups.borland.com> <MPG.184c12ae2a6c1ab098a256@newsgroups.borland.com> Subject: Re: Anyone could correct this for me "set transaction name "tran1" read write committed;" Thank you Date: Tue, 26 Nov 2002 01:59:24 +0800 Lines: 38 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 218.102.116.179 Message-ID: <3de264f9$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1038247161 218.102.116.179 (25 Nov 2002 09:59:21 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail