|
Ok, I am at a loss here. This is only part of the code I am working on but in the 1st step I am creating a table (temporary or permanent) from the master table to identify rows that I want to delete from several related table as well as the master table. In the next phase I am trying to pull some data to verify row counts after the deletion process is complete. The problem I am having is that the 2nd process is trying to run at the same time the 1st process is running. The table is still building. Questions is two fold. Why and how do you keep this from happening. Thanks for the help. I feel like I have been asking a lot of questions lately and appreciate all the help I have been getting.
Stephen Breen
-- Create table to id rows to be deleted - in this case all allied breakdowns in master - id is pon Write ' -- Project deltable from master using pon where breakdat le 12/31/00 Project deltable from master using pon where custnub2 in (sel custnub2 from customer where parentcustid = 101) -- Create index on del table to speed things up Create index #none on deltable (pon asc) Write ' '
Write 'Vendeval'
|
