Hi all,
I have a csv table of data that includes x and y coordinate coordinates
that I want to insert into a spatialware sql server database. That part
is easy enough, but I want to then create the points on the server side.
This is the first time that I am trying to do object creation and
manipulation on the server through spatialware - normally all of this is
done through MI Pro.
I have inserted the data into the table on the server that has been
created with easyloader (and then had the data deleted), and I get the
records in OK. I am using an ado recordset, and on the program side I add
all the data to the recordset and the do an update. THis doesn't allow me
to create the spatial points as I add them to the recordset.
I thought I would then update the table with a command like this
update dbo.T_FTPSITE_RAWDATA_MKYMTDATA set sw_geometry =
'ST_POINT(longitude,latitute)'
where longitude and latitude are the fields that have the data for x and y
coordinates expressed in the projection of that table.
It seems to run OK, but then when i open the table up in MapInfo, there
are no objects in the table.
I am concerned that the field references won't carry through to the
procedure.
Is this syntax right, or should I use a stored procedure?
Help,
thanks r
--
________________________________________________
Robert Crossley
Agtrix P/L
9 Short St
PO Box 63
New Brighton 2483
Far Southern Queensland
AUSTRALIA
153.549004 E 28.517344 S
P: 02 6680 1309
F: 02 6680 5214
M: 0419 718 642
E: [EMAIL PROTECTED]
W: www.agtrix.com
W: www.wotzhere.com
skype: robertcrossley
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16653
