Not always. If there are no output parameters it may assume that some DML
was executed. Otherwise, why else would you call a stored procedure that
didn't have any output?

One of the difficulties with InterBase is there isn't a way for me to know
if a stored procedure actually modified any rows or not.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <antoni.aloy@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, May 09, 2002 11:41 PM
Subject: RE: [IBO] Return from SP always starts Transaction


>
> >
> > > I have changed StoredProcForSelect and StoredProcHasDML
> > to no avail.
> >
> > StoredProcForSelect tells IBO that you are expecting a dataset to be
> > returned. StoreProcHasDML says that the proc is going to perform an
> > insert, update or delete operation. But neither of them causes the
> > transaction to finish. Only Commit or Rollback can do that.
> >
>
> But the commint is authomatic if you have autocommit flag on isn't it?
> ----
> Toni Aloy