Can you be more explicit about exactly what error occurred? You say "it
hung". What exactly was the behavior/indicator that you had a problem?
For example, did it just stick on a Pause command? Or did it throw up an
error box?
Also, and I know this is a dumb question, and I mean no insult, but I just
hate making assumptions...the second file you're opening is a different
file, right? You just don't make that explicit, and again, I dislike
making assumptions, but you do say "the same records again", and that is at
least ambiguous, although it could be read to mean that you are trying to
reprocess the records you processed before. (Can you tell I get in trouble
for asking questions like this all the time? :-) I just can't seem to
learn not to.)
Henry Taylor
Applications Analyst
Lutheran Health Network
Ph. (260) 425-3914
"Mickey Sherbett"
<[EMAIL PROTECTED] To: <[EMAIL PROTECTED]>
OM> cc:
Sent by: Subject: RE: [Talk] DATA STATION
[EMAIL PROTECTED]
TATION.COM
02/27/2004 10:17 AM
Please respond to Talk
Below is the way we are using for Reading a delimited file.
Notice the IF D ("Status") <> "Done". This was in the Online
Documentation under Boston Workstation 6.5.
But I looked at the Flat File Sample on the Web Site the IF D("Status")
<> "Done is not in the sample script.
I guesss I do not understand the Status and how the .bds file works yet.
Wait 1
D.Open_ "C:\Myfiles\Scripts\IVLISTS\log\carts.txt", ftDelimited
Do
If D("Status") <> "Done" Then
Stable 0, 3
Wait 1
Enter D("CART")
D("Status") = "Done"
End If
D.Next_
Loop Until D.EOF
D.Close_
Wait 1
Thanks,
Mickey Sherbett, Senior Analyst
DCH Regional Medical Center
809 University Blvd. E.
Tuscaloosa Al. 35401
205-759-7167
[EMAIL PROTECTED]
The information contained in this email message is confidential information
intended only for the use of the individual or entity named above. If the
reader of this message is not the intended recipient or the employee or
agent responsible to deliver it to the intended recipient, the reader is
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ross Stolle
Sent: Friday, February 27, 2004 8:31 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [Talk] DATA STATION
Mickey,
I assume you have an IF statement saying not to do the
record if it has a status of DONE. Change the IF statement to run if
it doesn't have a status of like DONE2 and after writing the file
change the status from DONE to DONE2.
Ross Stolle
Integration Engineer
Avera McKennan Hospital
Sioux Falls, SD
-----Original Message-----
From: Mickey Sherbett [mailto:[EMAIL PROTECTED]
Sent: Friday, 27 February, 2004 8:07 AM
To: [EMAIL PROTECTED]
Subject: RE: [Talk] DATA STATION
Yes we do a D.Close_ after we finished the Do Loop. I did not
see an extra Open. It seems to be accessing the .bds file which
had the record number and a Status of Done, which causes the Do
Loop to do nothing.
Thanks,
Mickey Sherbett, Senior Analyst
DCH Regional Medical Center
809 University Blvd. E.
Tuscaloosa Al. 35401
205-759-7167
[EMAIL PROTECTED]
The information contained in this email message is confidential
information intended only for the use of the individual or entity
named above. If the reader of this message is not the intended
recipient or the employee or agent responsible to deliver it to
the intended recipient, the reader is hereby notified that any
dissemination, distribution or copying of this communication is
strictly prohibited.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Corinna Robertson
Sent: Thursday, February 26, 2004 2:06 PM
To: [EMAIL PROTECTED]
Subject: RE: [Talk] DATA STATION
you more than likely have an extra open, every time you open
the file it goes back to the first record
Thanks,
Corinna Robertson
Boston Software Systems
[EMAIL PROTECTED]
www.bostonworkstation.com
The Essential Tool for Healthcare Integration
866-653-5105 x 8
603-598-5122
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Mickey Sherbett
Sent: Thursday, February 26, 2004 11:36 AM
To: [EMAIL PROTECTED]
Cc: Rich McNeil; Jeff Lee
Subject: [Talk] DATA STATION
Rich,
We just incorporated the Data Station in the new 6.5
Script we wrote to read a delimited data file.
The first time we run it, it processed the file and
all the records. When we called it up and ran it a second
time it hung at the point where we should have open
the file and started reading the same records again.
Have I missed something?
Thanks,
Mickey Sherbett, Senior Analyst
DCH Regional Medical Center
809 University Blvd. E.
Tuscaloosa Al. 35401
205-759-7167
[EMAIL PROTECTED]
The information contained in this email message is
confidential information intended only for the use of the
individual or entity named above. If the reader of this
message is not the intended recipient or the employee or
agent responsible to deliver it to the intended recipient,
the reader is hereby notified that any dissemination,
distribution or copying of this communication is strictly
prohibited.
____________________
Confidentiality Notice: This e-mail message, including any attachments, is
for the sole use of the intended recipient(s) and may contain confidential
and privileged information. Any unauthorized review, use, disclosure, or
distribution is prohibited. If you are not the intended recipient, please
contact the sender by reply e-mail and destroy all copies of the original
message.
