Steve:

A couple of questions…since you posted the same question on both lists I am not sure what version or R:Base you are using, i.e. 6.5++ or 7.1. Also, have you tried to TRACE the program with MESSAGES and ERROR MESSAGES On? This would allow you to go one line of code at a time and it would show if you have any errors. TTBOMK, commands execute in a sequential manner in R:Base and they wait until one command is executed before moving to the next command with the only exemption that I can think of being  the LAUNCH command. Again. Running the code with TRACE would show where the problem is or if a command is executing abnormally.

Javier,

 

Javier Valencia, PE

President

Valencia Technology Group, L.L.C.

14315 S. Twilight Ln, Suite #14

Olathe, Kansas 66062-4578

Office (913)829-0888

Fax (913)649-2904

Cell (913)915-3137

================================================

Attention:

The information contained in this message and or attachments is intended

only for the person or entity to which it is addressed and may contain

confidential and/or privileged material.  Any review, retransmission,

dissemination or other use of, or taking of any action in reliance upon,

this information by persons or entities other than the intended recipient

is prohibited. If you received this in error, please contact the sender and

delete the material from all system and destroy all copies.

======================================================

 

-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]On Behalf Of Steve Breen
Sent: Monday, May 02, 2005 9:40 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Process start before 1st one is complete

 

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 '
'Write ' '
Write ' Creating Table of POn's for Deletion '

-- 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 ' '
Write ' '
Write ' The Following will calculate a list of Table Information '
Write ' '
Write ' '
Write ' '

 

Write 'Vendeval'
Compute Vendorevalcnt as Count POn from vendoreval
show var Vendorevalcnt
Write ' '
Compute VendorEvalDel as count POn from VendorEval where pon in (select pon from DelTable)
Show var VendorEvalDel
Write ' '
set var Vendorevalfnl int = (.Vendorevalcnt - .VendorEvalDel)
show var Vendorevalfnl

 

 

Stephen Breen

 

 

 

 

 

Reply via email to