>
>What to do: Put a transaction around. But here is the problem:
>Beeing in a transaction VFP does not allow a requery, MM Bizobjs need a requery for every kind of loading data. Now I am in a really bad shape.
>If I just need to lookup anything durig this transaction it fails !
>
>My szenario is much more complicated and it is definitly not possible to load alle Bizness Objects before the Transaction starts.
>
>The steps I need to perform are many small steps the Bizobjs already are able to do and now I can't put them together because of this problem ?
>


Yeah, that's a major limitation with VFP transactions. It makes it nearly impossible to write true black-box code. I ran into this with a security class I had written for a website. I had a user object and a usergroup object. I needed to add a new user, then add that new user to a user group. I wanted to wrap the whole thing up in a transaction, which I couldn't do because of a requery in one of the objects. I ended up having to pull the logic from both objects out and making sure I requeried before the transaction. It was a major pain since I had to reproduce functionality my objects already had. This essentially became an "event" type object. However, instead of coordinating multiple bizobjs, I cut and pasted coded into it from them. Very ugly. This wouldn't be an issue with a transactional database like SQL. Sorry, I didn't find any nice workarounds (but I'd love to hear if someone else has!).