Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Conflict between auditing and transactions
Message
From
25/07/2007 20:48:53
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
25/07/2007 20:47:50
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 6 SP5
Miscellaneous
Thread ID:
01243602
Message ID:
01243656
Views:
26
>>How about redirecting the auditing of the import into a readwrite cursor based on the audit table, then when import is done, append from it into the audit table? You could wrap it into two levels of transaction (well, maybe), the inner handling the import only, and if it goes right, then do the append audit too. Since the audit isn't really triggering anything else, the append should be smooth and fast.
>
>I'll have to try it, but the procedure sounds ... well, it sounds sound.
>
>Did you ever encounter any similar problems in your own applications?

Not really - the large imports and busy networked apps usually managed to live in separate universes. I was lucky.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform