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