I don't know if you can do what you are attempting to do. Normally a Set Fields SQL statement reads from the ARSystem database. Look at your error message it's an Oracle error. I'm assuming your underlying database is Oracle, correct? -- Chris Danaceau AttivaSoft Solutions Architect
________________________________ From: Action Request System discussion list(ARSList) on behalf of John Kelley Sent: Thu 4/16/2009 5:13 PM To: [email protected] Subject: SQL statement Need a little help with an SQL statement. I am trying to populate fields in INC management from an Access Database on a shared network drive. My set field SQL statement so far is : SELECT * FROM File: //usranfb/transfer/Shopinfo/shopdetail.mdb WHERE SHOP_PFCNTR = $Shop number$ When I populate the shop number in my INC I get the following error. "ARERR [552] Failure during SQL operation to the database : ORA-00903: invalid table name" I don't think it knows where the location is. Help ************************************************************* This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
