Greetings, In general, the DataStation takes a read only approach to the data it accesses so it does not provide direct update features (except for Excel).
So the updating would go through something like ADO etc. Regards, Thom Thom C. Blackwell Product Manager Boston Software Systems (866) 653-5105 ex 807 www.bossoft.com <http://www.bossoft.com/> Sign up for my weekly webinar! <http://www.bostonworkstation.com/customer_center/special_events.aspx> LEGAL NOTICE Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately, then delete this message and empty from your trash. From: [email protected] [mailto:[email protected]] Sent: Thursday, December 10, 2009 4:21 PM To: Talk Subject: [talkbws] ODBC Datastation Hello Everyone, Has anyone used the ODBC datastation connection before? I'm connecting to an SQL server to pull the record set needed for the updates that I'm applying to the system. Can that connection update the table where I'm pulling the records from directly in the database? or do I have to go through and push an update manually using VBA? Thanks. ................................... Brian Van Grinsven, MCP Integrated Systems Specialist Medbuy Corporation [email protected] www.medbuy.ca Tel: 519.652.1688 ext. 114 Fax: 519.652.2788 Building Partnerships in Healthcare ********************************************************************** This e-mail and any attachments may contain confidential and privileged information. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient is unauthorized and may be illegal. ********************************************************************** --- 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
