Re: MI Why does this select fail...

[Michelle Smith]

I had a similar problem.  I may have taken the long way round, but I ended up fetching each object then testing it using the obj_info_type & then executing any changes if required: Dim obj_type as smallint count = tableinfo(table,TAB_INFO_NROWS) for i = 1 to count Fetch i from table     obj_type = objectinfo(table.obj,OBJ_INFO_TYPE) If obj_type = PLINE Then     execute changes, or store in a temp table End If   Next   Ta, Michelle. ----- Original Message ----- From: Scott Fagg To:     Sent: Monday, May 29, 2000 4:26 PM Subject: MI Why does this select fail... select * from TableA where ObjectInfo(obj , OBJ_INFO_TYPE) = OBJ_TYPE_PLINE into TableB fails with : "Datatype mismatch in expression" According the the mapbasic references, ObjectInfo returns an SmallInt when called with OBJ_INFO_TYPE. I'm trying to select all of the objects of type PLINE from a table into another table. ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]