What does the .bds look like? There's flag called DirectUpdate that should be set to true.
From: [email protected] [mailto:[email protected]] Sent: Sunday, January 17, 2010 4:00 PM To: Talk Subject: [talkbws] .NET and datastation 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] --- 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
