Problem using QTP to delete repeating records

Tom Shelton tjshel@birch.monsanto.com
Mon, 11 May 1998 14:10:45 -0500


We are using PowerHouse 710E on an Alpha with VMS 6.2 and are encountering
a problem using QTP to delete records from an RMS file with a repeating
primary key.  Periodically we get a record has changed error message.
Sometimes we are deleting all of the detail records and sometimes just
part of them (based on other selection criteria).  We try to delete the
detail records by accessing the primary key, sometimes with a select to
limit the deleted records.  Running the QTP multiple times will eventually
delete all of the records, but we would like to change the QTP to do all
of the deletes in one pass.

Does anyone know what causes this problem, and more to the point how we
can get around it?

Thanks,
Tom Shelton

TJSHEL@Birch.Monsanto.COM
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.