if you open the connection you'll start the default transaction implicitly
but I really think you can ask this over at the delphi groups
Alan
-----Original Message-----
From: julien_ferraro [mailto:j.ferraro@...]
Sent: Friday, 30 August 2002 17:55
To: ib-support@yahoogroups.com
Subject: [ib-support] Re: TIBUpdateSQL ?


I don't really know. I was guessing this because there is no
CommitUpdate Method for TIBQuery like TQuery has.

BTW, I have an other little question

With TQuery I was doing

MyQuery.Post;
MyQuery.ApplyUpdates;
MyBase.Commit;
MyQuery.CommitUpdates;
MyQuery.Close;

And Now I'm Doing

MyIBquery.Post;
MyIBBase.ApplyUpdates([MyIBQuery]);
MyIBTransaction.CommitRetaining;

I don't like really to do CommitRetaining. I was thinking first that
a simple commit will do it. But I had an error "Transaction already
exists" or something like this, when I tried to do
MyIBTransaction.StartTransaction even if it was the first call to
this Method in my application. I thought that, like in IBAccess, you
have to open a transaction just to read datas. Is it true ? Is my
code with IBquery and IBDatabase correct ?

Thank you

Julien

PS : I know this is not a Delphi group. But I thought that Firebird
Pro's can help me more about those Firebird tricks :)

--- In ib-support@y..., "Alan McDonald" <alan@m...> wrote:
> Why is this? Is there something Firebird does/does not like about
cached
> updates and the use of IBQuery and IBUpdateSQL components?
> Alan
> -----Original Message-----
> From: Woody [mailto:woody.tmw@i...]
> Sent: Friday, 30 August 2002 0:23
> To: ib-support@y...
> Subject: Re: [ib-support] TIBUpdateSQL ?
>
>
> This is more a Delphi specific question, even though on the
Borland
> groups,
> as soon as you mention Firebird they will direct you here. You
can either
> go
> to using ClientDatasets or TIBDatasets or IBO. Using TIBQuery
should be
> reserved for non-interactive updating of data and displaying,
not editing.
>
> Woody (TMW)
>
> ----------------------
> "To invent, you need a good imagination and a pile of junk."
> Thomas Edison
>
> ----- Original Message -----
> From: "julien_ferraro" <j.ferraro@n...>
> To: <ib-support@y...>
> Sent: Thursday, August 29, 2002 7:27 AM
> Subject: [ib-support] TIBUpdateSQL ?
>
>
> Hello,
>
> I'm still porting a Delphi application from Access to Firebird. I
> understood that CachedUpdates are not the right way to use
TIBquery.
> Is it false ? Or do I have to replace all my TIBUpdateSQL with
some
> TQuery doing the same action ?
>
> It's not a pb if I have to change this. I just want to do the
right
> thing for Firebird :)
>
> Thank you
>
> Julien



Yahoo! Groups Sponsor
ADVERTISEMENT



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]