What I do is periodically close the file. I'll call this after getting
the next record to see if I should close the file and if so it opens the
file back up at the correct record.
*******************************
Sub zCheckSave(iRecord As Integer, sFile As String)
' Chad Kemp 3/14/08
' Used to save updates to xls file after #N records.
'
' For example:
' If D.Record Mod 500 = 0 Then zCheckSave 500, F("FileIn")
Dim iTemp As Integer
iTemp = d.Record
If d.Record Mod iRecord = 0 Then
d.Close_
d.Open_ sFile, ftExcel
d.Record = iTemp
End If
End Sub
Chad Kemp
Information Systems Analyst
Firelands Regional Medical Center
419-557-7874
________________________________
From: [email protected] [mailto:[email protected]]
Sent: Wednesday, August 19, 2009 2:19 PM
To: [email protected]
Subject: [talkbws] Multiple BDS files and D.Report
I am attempting to create a report from a large text file (2600 rows)
and when I find what I am looking for I set the status in Datastation =
1 this way BWS will just re-write those files into a smaller file.
My problem is due to the size, BWS is creating two BDS files (BDS, and
BDS1) but at time of compiling the report it is ignoring the BDS1 file
and not writing my files into the output report. The current file I am
testing against the records I wish to write are 1518 thru 1532 , I could
see the status set = 1 in the BDS1 file. But they do not show up in my
output report.
Could anyone help me solve this issue
Paul Yagid
Women's Health
22 Waterville Road
Avon, CT 06001
phone: 860.678.5566
email: [email protected]
________________________________
"CONFIDENTIALITY NOTICE: If you have received this e-mail in error,
please immediately notify the sender by e-mail at the address shown.
This e-mail transmission may contain confidential information. The
information is intended only for the use of the individual(s) or entity
to whom it is addressed. Any disclosure, distribution, copying or use of
the information by others is strictly prohibited. Please delete it from
your files if you are not the intended recipient. Thank you for your
compliance"
---
To post a message to this list, send mail to: [email protected]
You are currently subscribed as: [email protected]
Unsubscribe in the customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk
.aspx
---
To post a message to this list, send mail to: [email protected]
You are currently subscribed as: [email protected]
Unsubscribe in the customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
