Thread View: borland.public.interbase.sql
4 messages
4 total messages
Started by NEWBIES
Mon, 25 Nov 2002 12:33
Anyone could correct this for me "set transaction name "tran1" read write committed;" Thank you
Author: NEWBIES
Date: Mon, 25 Nov 2002 12:33
Date: Mon, 25 Nov 2002 12:33
4 lines
1112 bytes
1112 bytes
"set transaction name "tran1" read write committed;" "commit;" What's wrong with above statement, interactive SQL don't accept;
Re: Anyone could correct this for me "set transaction name "tran1" read write committed;" Thank you
Author: Craig Stuntz TeamB
Date: Mon, 25 Nov 2002 15:58
Date: Mon, 25 Nov 2002 15:58
16 lines
1512 bytes
1512 bytes
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
Re: Anyone could correct this for me "set transaction name "tran1" read write committed;" Thank you
Author: 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
Re: Anyone could correct this for me "set transaction name "tran1" read write committed;" Thank you
Author: Craig Stuntz TeamB
Date: Mon, 25 Nov 2002 18:12
Date: Mon, 25 Nov 2002 18:12
17 lines
1699 bytes
1699 bytes
In article <3de264f9$1@newsgroups.borland.com>, NEWBIES@netvigator.com says... > > I read from SQL reference (extracted InterBase Documentation Beta): "Starts > a > transaction and optionally specifies its behavior. Available in SQL, DSQL, > and isql." Read further. Named transactions are in embedded SQL only. -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
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads