>Hi All,
>
>We are having problems trying to update a large number (>500) records in a transaction. I think the root of the problem lies in an inability to achieve sufficient record locks. I'm hoping someone here can point me to either a solution or perhaps a better way to approach the update problem.
>
>We are using table buffered views ( CURSORSETPROP('BUFFERING',5)) in VFP6. The work stations use WIN98/95 and the data is on a Novell file server.
>
>We want to post a payroll to the general ledger. In our approach we want a single journal entry to represent the payroll. For simplicity purposes assume only a few GL accounts are involved. So we have a journal entry header record and a handful of detail records. But we also want to flag the 1000 + paycheck detail records with the key ID of the GL detail records to establish an audit trail.
>
>We envelope the update of all four views in a transaction but it fails. Actually the failure is not a transaction issue as much as it is a failure to TABLEUPDATE the paycheck details.
>
>Playing around with this shows that there is an apparent limitation on the number of records around the 500 mark.
>
>Any help is appreciated.
>
>Thanks, Ken
Ken,
It's Novell again and around 500 :) Few days ago there was a discussion about this. Check that thread if that helps you. Search keywords as far as I remember "record lock novell transaction".
Cetin