More on the issue:
I am confident that the references to the fields in the update command is
part of the problem as if I use the command:
update dbo.T_FTPSITE_RAWDATA_MKYMTDATA set sw_geometry =
'ST_POINT(147.5,-21)'
I get a nice point for all my records
so it seems that I need to somehow make the update command use the column
names - any solutions?
Also if there was a way of updating records that didn't have a spatial
object would also be nice
eg. update dbo.T_FTPSITE_RAWDATA_MKYMTDATA set sw_geometry =
'ST_POINT(longitude,latitute)' where isNull(sw_geometry)
r
On Fri, 03 Jun 2005 11:23:15 +1000, Robert Crossley <[EMAIL PROTECTED]>
wrote:
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: 16654
