Hi Boston Support, I'd like to know how to update an SQL Database after a record is processed. I could probably get a work a round to this with ODBC and running an sql statement after grabbing the record ID, but maybe there is an easier way? Thanks.
Scott Chen Specialist - Developer Regional Business Office Providence Health & Services Portland, OR Tel: (503) 215-4441 Email: [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Thom C. Blackwell Sent: Monday, August 06, 2007 9:00 AM To: [email protected] Cc: [EMAIL PROTECTED] Subject: RE: [Talk] Updating database after record is processed Greetings, The DataStation supports writing back to the source data only if that source data is Excel. The other file types do not do this. I'm assuming by "database" you're not meaning Excel. If you are meaning Excel, they you want to check the "write back to source" option when you're building the Open command in your script - the Help describes what to do here - or of course the support folks could help too. If you're wanting to write back to a SQL database we've got a guy here that's good with that type stuff who could help you out here with that. Send in a ping to [EMAIL PROTECTED] if this is the case. If it's a flat file format - writing back directly gets sort of dicey because you'd need to figure out "where it goes". If it were me, I'd look into the DataStation reporting feature since it could easily output a "cloned" file that has the "updated" value. .. And perhaps the Report feature does what you want here anyway (although in a different way) , if what is desired is a record of what the script processed. Regards, Thom Thom C. Blackwell Product Manager Boston Software Systems (866) 653-5105 ex 807 <http://www.bossoft.com> www.bossoft.com 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] On Behalf Of Chen, Scott C Sent: Monday, August 06, 2007 11:32 AM To: Boston WorkStation Group (E-mail) Subject: [Talk] Updating database after record is processed Hi, I would like to update a record in my database after I process it. I know how to pull data with datastation, but not sure how to update the database after I process a record. Thanks. ------ ole0.bmp Scott Chen Specialist - Developer Regional Business Office Providence Health & Services Portland, OR Tel: (503) 215-4441 Email: [EMAIL PROTECTED] DISCLAIMER: This message is intended for the sole use of the addressee, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. DISCLAIMER: This message is intended for the sole use of the addressee, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
<<image001.gif>>
