Dave Suggest you use VB to drive all the steps - look at the Integrated Mapping sections of the MapBasic guide and send your individual MapBasic statements to MapInfo rather than using an MBX.
Its slower than an MBX because the MapBasic statements are uncompiled but for an unattended batch job that may be less important. We've got one I wrote to extract data from Oracle Spatial and it runs fine every week - the advantage is that you've got much more error trapping and reporting through VB - use the LastErrorCode property on MapInfo to track any errors on MapInfo. And porting MapBasic to VB isn't hard. HTH Paul Crisp Syntegra Innovation Place Delta Bank Road Newcastle NE11 9DJ Tel 0191 461 4522 Fax 0191 460 1987 -----Original Message----- From: Dave King [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 09:27 To: '[EMAIL PROTECTED]' Subject: MI-L Running MapBasic through MS Scheduled tasks Hello list, I'm hoping that someone can shed some light on a problem that I am having when trying to run a mapbasic script through Microsoft Scheduled Tasks on Windows NT 4.0. The problem is that I am unable to run my mapbasic script in it's entirety through scheduled tasks. The script itself is fairly simple, essentially it does 4 things: * It opens a set of tables * It appends then saves the tables * The graphical style of the contents of the appended tables is changed * It then shells out to a Visual basic routine which copies the tables to an archive folder There is nothing wrong with the mapbasic script script itself, it works fine when run normally. When run through scheduled tasks it never completes. No error messages are generated and MapInfo does not crash. I therefore do not know where the problem occurs. I have played about by simplifying my mapbasic routine and can get other scripts to run. The strange thing is that if I remove the part of the script that changes the graphical style of my new appended tables then the script runs fine through task scheduler. The tables are appended and it shells out to the visual basic routine without problem. The problem definitely seems to be with the part of the code that changes the table style. As I say this all runs fine when the script is run from Mapbasic so I really don't understand what is happening here If anyone has any ideas or solutions I'd be grateful as I'm really stuck here. Thanks for your help David King ************************************************************************* The contents of the e-mail and any transmitted files are confidential and intended solely for the use of the individual or entity to whom they are addressed. Transport for London Street Management hereby excludes any warranty and any liability as to the quality or accuracy of the contents of this e-mail and any attached transmitted files. If you are not the intended recipient, be advised that you have received this e-mail in error and that any use, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. If you have received this e-mail in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept for the presence of computer viruses. ************************************************************************* --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 3428 ******************************************************************** 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 ********************************************************************
