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
