Thanks for the help again guys (Lars, Anand),
It seems that there is a solution to generating lines from a vb
recordset. I am rather suspicious that some of the issue was an
incomplete install of the spatialware patch, as I reinstalled spatialware
and the patch (this time getting rid of georgetown and world db), and code
I had tried before seemed to work (I swear!). Also the error messages
seemed to be different (this morning there were quite a few missing
objects). Anyway the technique was quite straightforward in the end.
First you need to use the same technique of a temporary table that acts as
an intermediatry, WITH no R-TREE indexing, but with a spatial column.
Except you also have one column that you write the script to generate the
object for that record, eg. a field C_VERTEX_LIST
You add the data to the recordset as per normal and the update (rs.update)
the table normally, and generate the script for the object in the
C_VERXLIST field like:
ST_Spatial(ST_Polyline(LIST{ST_Point( 149.0715,-21.30255),
ST_Point( 149.0712,-21.30432)}))
(Note no paranthesis)
You can then create the spatial objects quite quickly by using a server
side sql
Update Table TempTable Set sw_geometry = C_VERTEX_LIST
and it works.
Appending this data to the Indexed target table can be doen with a
standard insert, and is quite quick.
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: 16718
