MapInfo Pro Developers User Group

The "Objects Move" moves a selected object on the map. Is there some other way to move an object not selected first? Like an update statement to reposition and rotate the geometry based on the objects id?

Hi Hans

Yes, there are a couple of functions that come to my mind:

Offset an object using change in X and Y:

• OffsetXY( object, xoffset, yoffset, units)
• CartesianOffsetXY( object, xoffset, yoffset, units )
• SphericalOffsetXY( object, xoffset, yoffset, units )

Offset an object using angle and distance:

• Offset( object, angle, distance, units )
• CartesianOffset( object, angle, distance, units )
• SphericalOffset( object, angle, distance, units )

Rotating:

• RotateAtPoint( object, angle, anchor_point_object )
• Rotate( object, angle )

All these are functions that take the object as input and returns the altered object. So you can use them directly in an update statement:

Update MY_TABLE

Set OBJ = CartesianOffset(OBJ, 45, 250, "m")

That is exactly what I need. Thanks.

Cool, sometimes I feel we need a better way to make people aware of the many functions of the MapBasic language. Even I struggle to find the right function or statement from time to time. I know it's there but I just can't seem to remember the exact name of it

I tried this (move object 10 meters east), but the sentence is invalid:

update MY_TABLE set Obj = OffsetXY(obj, 90, 10, "m") where ID=15575

I get an error about the Id column in the where statement:

Cannot perform this operation on field ID.

How can I apply the move or rotate operation to only some objects and not the whole table?

I'm sure @Peter Horsbøll Møller? ? will be able to give a better answer, but here are my 2 cents:

Why not perform a select of the object into a temporary table and then perform the offset?

Select the object(s) from myTable into myTemp:

SELECT * FROM myTable WHERE ID = 15575 INTO myTemp

and then perform the offset on the object(s) in myTemp:

UPDATE myTemp SET Obj = OffsetXY(obj, 90, 10, "?m")

That's how I would do it, @Kobi Irom? 

The Update statement of the MapBasic SQL does only support a very basic condition: A specific RowID:

Update table Set column = expr [ , column = expr, ...] 

[ Where RowID = id ]

where id is the number of a row in the table

But of course use the NoSelect keyword so that the query doesn't mess with any current selection and the Hide keyword so that the query doesn't show up in the user interface:

SELECT * FROM myTable WHERE ID = 15575 INTO myTemp NoSelect Hide

The Hide keyword we recently learned about in the MapInfo Pro Developer group.