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 also have "conversion error from string" Err from my SP s

One SP reads from 4 table and writes data to 5 separate table according to a one record. Thats why I have to be very careful about the data...

Regards
Burak

----- Original Message -----
From: Phil Shrimpton
To: ib-support@yahoogroups.com
Sent: Friday, January 10, 2003 2:09 PM
Subject: Re: [ib-support] No success at SP&TRIGGER


On Friday 10 January 2003 14:03, you wrote:

Hi,

> Becouse of not supporting Nested Transaction, I have to remove many
> refrential integrity rules at my server side becouse main modules and SP's
> running at separate transactions...
>
> Most of the modules at my program starts a transaction for the record and
> another transaction runs the sp's before post or before delete.

Is there any reason for doing this in two separate transactions?

Phil

--
Linux 2.4.4-4GB
12:07pm up 3:50, 1 user, load average: 0.08, 0.05, 0.02


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



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



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