On Saturday 11 January 2003 11:54, Burak OZLER wrote:

Hi,

> > Is there any reason for doing this in two separate transactions?
> >
> > Yes
> > if user entered a wrong data to a any field SP Transaction rollsback
> > and give user chance to correct the data... If I use same transaction
> > for record and SP, when you roll back the transaction all the data that
> > user has entered goes away...
>
> I would say this is more of a client side/GUI issue than a FB one. There
> is nothing in FB that "will make the data go away" on the client side, that
> is down to the way you have designed your app.
>
> if SP's works bug free, I have no problem but SP's have bugs...

You need to post the SP that you have problems with then.

> If you
> write a accounting or financial app you'll understand why I need this type
> of design..

I do write financial applications, thats why somebody doing validation and
'posting' in two separate transactions makes my alarm bells ring.

Phil
--
Linux 2.4.4-4GB
7:10pm up 1 day, 59 min, 1 user, load average: 0.49, 0.10, 0.03