More spatialware stuff,

Is there a stored procedure in spatialware that will update the table extents in the Mapinfo_Mapcatalog?

I can sort of get there I think with an update query like the following (although this isn't working yet - it may need a stored proc with a temp table):

update MAPINFO.MAPINFO_MAPCATALOG (DB_X_LL,DB_Y_LL,DB_X_UR,DB_Y_UR)
exec sp_spatial_query 'select Min(hg_llb_x(sw_geometry)), Min(hg_llb_y(sw_geometry)), Max(hg_Urt_x(sw_geometry)), Max(hg_Urt_y(sw_geometry)) from t_gps_locs'
Where TABLENAME = 't_gps_locs'

But it would be easier if there was one already written.

Also my app generates tracks from points, and yet the tracks seem to be displaced slightly from the points they were created from. Looks like a projection problem to me if it were in MapInfo, or a bounds issue. Am going to investigate further, but are there some tricks to generating points?

TIA,
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: 16719

Reply via email to