Thank you Warren. You're right. I just realized that the statement to
create the points was missing from my posting. This is the statement I
had in my routine:
Update MyTable Set obj = CreatePoint(x, y)
The long, lat info is in fields X & Y. When I run the routine, it
creates one point for the whole file. I tried also the "insert into"
instead of the update expression.
Any idea why? And I appreciate for the other suggestions.
Thank you,
Othman Issa
Bell Canada
Scarborough, ON
416-296-6000
Warren Vick, Europa Technologies Ltd. wrote:
> 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]
