sometimes you have to do force the returned variable, something like
 
select * from tableA  where int(ObjectInfo(obj,OBJ_INFO_TYPE)) = OBJ_TYPE_PLINE into tableB
 
seems to happen a lot where the returned variable type is a small integer.
 
Robert.

Robert Crossley
Wild Lime
Suite 1, 169 Newell St
CAIRNS 4870 AUSTRALIA
www.wildlime.com
Ph: 61-7-40337644
Fax: 61-7-40337688
[EMAIL PROTECTED]

----- 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]

Reply via email to