Re: buffering & transactions
From: Thomas Ganss (tganss_at_t_dash_online_dot_de-remove-all-after-first-real-dash_at_yahoo.com)
Date: 03/20/05
- Next message: kd: "Re: MSMQ in VFP8.0"
- Previous message: Lew: "VFP8 Help entry for Arrays and Select - SQL ... Wrong or what?"
- In reply to: Paul Pedersen: "Re: buffering & transactions"
- Next in thread: Ook: "Re: buffering & transactions"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 20 Mar 2005 06:11:07 +0100
Paul Pedersen schrieb:
> Thanks.
>
> I open a transaction only when saving. But in this unusual case, "Save" is
> an extended process involving calculations and several updates to various
> tables. (Just what transactions were made for, I think.) Some of those
> updates are simple inserts (sql), so offhand I don't see a need to buffer
> those. I have them in TRY blocks and can rollback if necessary.
In vfp6 we ran into trouble using transactions on a save process that
was coded to include (yes, I know ... not my design<g>) BizObject checks
on the data to be saved and some optional protocols and/or audit trails.
Dunno if there still is a problem, but if you get chr(0) in your saved
tables, this can be one reason. But there are some other (even
documented at MS) ways to get invalid data.
my 0.02 EUR
thomas
- Next message: kd: "Re: MSMQ in VFP8.0"
- Previous message: Lew: "VFP8 Help entry for Arrays and Select - SQL ... Wrong or what?"
- In reply to: Paul Pedersen: "Re: buffering & transactions"
- Next in thread: Ook: "Re: buffering & transactions"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
