Hello All!
I am building a script in .NET (c#) referencing BostonWorkstion to easily read
through an excel spreadsheet and script some data entry through a Java
connection. My problem is this... I have not found a way to update
Datastations variables. In VBA we would use b.D("status"). But that does not
appear to be valid in .NET. I can reference the value of a datastation
variable by using b.Value("status") but that is not updatable. Am I doing
something squirrley or is there a different way to update the datastation
variables in .NET? I am guessing flags wouldn't be updateable either since
they have same syntax (b.F("status")), but I haven't tried them.
Below is what I attempting to do ... thanks in advance for any suggestions!
John Mulligan
ProMedica Health System
// Create a bws object and the load the spreadsheet into a
collection
BostonWorkStationClass b = new BostonWorkStationClass();
string mm = "";
string cc = "";
// Open the file
b.D.Open_ (fileName,
BostonWorkStation70.enumFileType.ftExcel,cc,ref mm) ;
// Go into a loop of all the records
do
{
// Set the user properties
mckUser.ID = b.Value("ID");
mckUser.LastName = b.Value("LastName");
mckUser.FirstName = b.Value("FirstName");
b.D("MyStatus") = "READY FOR SCRIPTING"; // <<<<<<<<<<
THIS WON'T WORK
// Move to the next row
b.D.Next_();
} while (b.D.EOF == false);
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
EMAIL CONFIDENTIALITY NOTICE
This Email message, and any attachments, may contain confidential
patient health information that is legally protected. This information
is intended only for the use of the individual or entity named above.
The authorized recipient of this information is prohibited from disclosing
this information to any other party unless required to do so by law
or regulation and is required to destroy the information after its stated
need has been fulfilled. If you are not the intended recipient, you are
hereby notified that any disclosure, copying, distribution, or action
taken in reliance on the contents of this message is strictly prohibited.
If you have received this information in error, please notify
the sender immediately by replying to this message and delete the
message from your system.
---
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
