Re: MI Re: Creating Points with MapBasic

[Warren Vick, Europa Technologies Ltd.]

Hello Othman,

> I hope someone could help me with this little annoying problem I had
> with creating points in MapInfo through a MapBasic routine.
> 
> My syntax is similar to this:
> 
> --------
> Create Map For Mapfile CoordSys Earth Projection 8, 66, "m", -79.5, 0,
> 0.9999, 304800, 0 Bounds (-7943771.23464, -10000887.8544)
> (8553371.23464, 10000887.8544)
> Map From Mapfile
> -----

These statement will not actually create point objects for you. They only "prepare" 
the MapInfo 
table and create a mappable layer. You need to set the "obj" field of each record of 
your data to a 
point object. Assuming your table "YourTable" and coordinate fields "Lon" and "Lat", a 
simple SQL 
update could be:

update YourTable set obj = createpoint(Lon, Lat)

In this example, your points will inherit the current symbol style in MI.

Alternatively, you can iterate through your data records and assign symbols 
individually with a 
single "update ... where rowid = ..." for each. 

Since point creation is usually too complicated for the undo system to work, you might 
as well 
speed this up a little by switching on fastedit and turning off undo. Before you 
update(s), do a:

set table YourTable fastedit on undo off

Regards,
Warren Vick
Europa Technologies Ltd, U.K.
http://www.europa-tech.com
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]