Hi Matt,
I think you'll need to drop the existing table or delete the records in this. Then you
can use the insert function to insert the new reocrds.
Remember that you can send a command to the SQL Server to delete the records instead
of doing it on the table loaded in MapInfo. You can use the Server_Execute() to get
commands executed in the database.
Or you can use the sw_MI_Import tool to upload the tables into SpatialWare:
sw_MI_import -s data source [-d login] [-p password]-t MI_table
[:[alias]:[range]]...[-t MI_table [:[alias]:[range]]]
[-f {logFile | -}] [-x transactionsize] [-k filegroup]
[-E] [-G] [-N] [-R] [-U] [-W]
This tool can be run from a DOS-prompt or from a bat file. See the SpatialWare
documentation for further information
Peter Horsb�ll M�ller
GIS Developer
Geographical Information & IT
COWI A/S
Odensevej 95
DK-5260 Odense S.
Denmark
Tel +45 6311 4900
Direct +45 6311 4908
Mob +45 5156 1045
Fax +45 6311 4949
E-mail [EMAIL PROTECTED]
http://www.cowi.dk
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 01, 2004 4:08 AM
To: [EMAIL PROTECTED]
Subject: MI-L Automating SpatialWare Upload
Hello All,
I have been uploading data to a SQL SpatialWare server via MapInfo EasyLoader. I want
to automate this process to upload new data, scheduled on a nightly basis. My question
is, does anyone know the MapBasic code to replace (overwrite) an existing table in the
SpatialWare database?
Thanks.
Regards,
Matt Robinson
GIS Officer
Bathurst City Council
*****************************************************************
"This message is intended for the addressee named and may contain confidential
information. If you are not the intended recipient, please delete it and notify the
sender. Views expressed in this message are those of the individual sender, and are
not necessarily the views of Bathurst City Council, unless otherwise stated.
For the purposes of the Copyright Act, the permission of the holder of copyright in
this communication may be taken to have been granted, unless stated otherwise, for the
copying or forwarding of this message, as long as both the content of this
communication and the purpose for which it is copied or forwarded are work related."
*****************************************************************
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe,
e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11218
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11219
