There are some people, who are always dissatisfied with everything.
And there's nothing man can do about it

Regards, Bogdan

Ps: And it's getting worse every day

> -----Original Message-----
> From: firebird-support@yahoogroups.com [mailto:firebird-
> support@yahoogroups.com] On Behalf Of buppcpp@...
> Sent: Thursday, June 16, 2005 1:51 PM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] COMMIT and ROLLBACK in SP
>
>
>
> ""Ivan Prenosil"" <Ivan.Prenosil@...> wrote in message
> news:<00c901c57260$074f6dc0$0e0110ac@prenosil>...
> > > I'm mainly concerned with compatibility with other databases that DO
> allow
> > > commits and rollbacks and that sometimes it makes sense.
> >
> > You are a bit confused by the term "stored procedure",
> > simply because different systems use it to refer to completely
> > different things.
> > In Firebird, stored procedure is sql command, and as any other
> > sql commands it is executed as atomic piece of code inside
> > transaction, where life cycle on transaction is controlled
> > by application.
> > The other databases you are talking about use the term "stored
> > procedure" to describe "stored script" or "stored macro" or whatever.
>
> I'm not confused, but I think you are...what in the heck are you talking
> about in the above statement?
> It's a stored procedure just like Firebird, but it supports commits and
> rollbacks.
>
> >
> > > Such as databases that allow a Stored Procedure (SP) to be called by
> the
> > > engine when it initially boots up.
> > > Or databases that allow you to schedule task which make calls to SP.
> >
> > Do those databases allow calling single statement, like Delete, without
> > using their SP ?
>
> Yes, why wouldn't it? Are you sure you know what a stored procedure is?
> >
> > > So just as you have "your" reasons for not having commits/rollbacks in
> SP, other
> > > database developers have found a real need for them...and I agree.
> >
> > I am not questioning your need for some feature.
> > I understand your reasons for wanting to easily run bunch of statements,
> > including commits/rollbacks, stored somewhere in the database.
> > The only problem is that you want to implement it in inproper place.
> > You just want new feature, something like Stored Script.
>
> ???
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.323 / Virus Database: 267.7.5/18 - Release Date: 15.6.2005