RE: MI-L SQL Select Error

2004-03-19 Thread Woody Woodruff
ning/index.htm -Original Message- From: Don Guerra [mailto:[EMAIL PROTECTED] Sent: March 17, 2004 10:27 To: MapINFO (MapINFO) Subject: MI-L SQL Select Error Thanks Spencer, that helped a lot. I was able to determine that 13 out of 893 objects were in fact not polylines and this is what'

MI-L SQL Select Error

2004-03-17 Thread Don Guerra
Thanks Spencer, that helped a lot. I was able to determine that 13 out of 893 objects were in fact not polylines and this is what's hanging up the SQL select. Thanks to Mike Cummings also for his suggestion, however I had already packed the table when I first got the error. Donald Guerra

RE: MI-L SQL Select Error

2004-03-16 Thread Spencer Simpson
"str$(obj)" for a polyline returns "Polyline", not "Pline". In addition, there is a "line" object type for which str$(obj) returns "line". You can use either of the two expressions below to search for rows that are neither lines nor polylines: not (str$(obj)=any ("line", "polyline")) instr(1,str

MI-L SQL Select Error

2004-03-16 Thread Don Guerra
O.K. I tried using the table name with the expression for the ObjectLen function as Terry McDonnell suggested..got the same result. Then I checked to see if these are in fact polylines as Bill Thoen suggested. All of the lines where selected meaning none are polylines. I even reversed this

MI-L SQL Select Error

2004-03-16 Thread Don Guerra
Hi, I am using SQL Select to sum object lengths. The selection table has one column from the base table and one derived column. The derived column is specified as Sum(ObjectLen(obj,"ft")) I get this error: "Could not fetch object from the current row, argument ObjectLen" The query