Title: ObjectInfo
|
Hi Guy,
Try this:
Select *
>From Table_Name Where val(chr$(ObjectInfo(obj, OBJ_INFO_TYPE) <> 7)) into
Out_Test3
This is because OBJ_INFO_TYPE returns a
smallint. For some reason MB cannot compare a smallint with an
integer.
The method above turns it into a string,
and then into an Integer.
Hope this helps,
Steve
Hi Folks,
We have just acquired MapBasic and I am writing a
data checking routine to flag errors in our data.
One thing I am trying to test for is objects that
are not polygons in a layer that is supposed to contain only
polygons.
When I tried :-
Select * From Table_Name Where (ObjectInfo(obj, OBJ_INFO_TYPE)
<> 7) into Out_Test3
I got the run-time error : Datatype
mismatch in expression.
I tried the ObjectInfo example in the
manual and it worked perfectly (of course). I can get the values of
(ObjectInfo(obj, OBJ_INFO_TYPE) into a table but I don't seem to be able to
test them (at least in a select statement).
I could test each row in the table
individually and build a results table a row at a time but I'm sure there
must be a better way!
Any help would be appreciated.
Cheers, Guy Matters.
|
