John Your problem is probably to do with string evaluation - usually a missing quote mark - try the statement interactively in the MapBasic window in MI Pro. and check that the PATH parameter is being correctly assembled - or halt your code and put the PATH parameter up on screen with a NOTE statement.
HTH Paul Crisp Syntegra Innovation Place Delta Bank Road Newcastle NE11 9DJ Tel 0191 461 4522 Fax 0191 460 1987 -----Original Message----- From: Bark, John [mailto:[EMAIL PROTECTED] Sent: 02 December 2003 11:18 To: [EMAIL PROTECTED] Subject: MI-L Server Fetch Statement I am having problems with a Server Fetch Into statement in MapBasic v6.5 and am looking for guidance. I can connect to our external database (Oracle) fine and can fetch the data from a oracle table using a SQL statement into a new table with a table name I specify. This table is created within an Microsoft Office directory on my c:\ drive with the name I specify. I would prefer this table to be created in one of my MapInfo data directories. I have added File and then the file path to the end of my Server Fetch statement but while this creates the table files in the directory I specify it does not give the files a name. If anyone has encountered this problem and can advise on how to resolve it I'd appreciate their help, Thanks in advance, John John Bark * [EMAIL PROTECTED] * www.marks-and-spencer.com ----------------------------------------------------------------------- Registered Office: Marks & Spencer p.l.c Michael House, Baker Street, London, W1U 8EP Registered No. 214436 in England and Wales. Telephone (020) 7935 4422 Facsimile (020) 7487 2670 www.marksandspencer.com Please note that electronic mail may be monitored. This e-mail is confidential. If you received it by mistake, please let us know and then delete it from your system; you should not copy, disclose, or distribute its contents to anyone nor act in reliance on this e-mail, as this is prohibited and may be unlawful. The registered office of Marks and Spencer Financial Services PLC, Marks and Spencer Unit Trust Management Limited, Marks and Spencer Life Assurance Limited and Marks and Spencer Savings and Investments Limited is Kings Meadow, Chester, CH99 9FB. These firms are authorised and regulated by the Financial Services Authority. ******************************************************************** This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person Thank you Check us out at http://www.syntegra.com ********************************************************************
