> 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. I would look at this side of
things first as the way you are currently doing it will cause a lot of work
at best, and lots of problems at worst.
Phil
--
Linux 2.4.4-4GB
6:13pm up 9:56, 1 user, load average: 0.15, 0.03, 0.01