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'
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
"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
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
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