ID de Oracle Spatial

[Anonymous]

Como puedo obtener con VB o Lisp el ID o entityid del elemento que fue importado a traves de una consulta por ubicacion desde Oracle Spatial a traves de AutoCAD MAP.

gracias

[luc_vanlinden]

Hello J

I guess you want to know how to query the entityid when features are read from Spatial.

I posted a similar question june last year:
"How does Map stores the Id of a queried features from Oracle Spatial ".

Without a clear response so far.

What I did, was the following:
I added an extra field in my feature table fe, myEntityid.
I added a trigger on this table that defines an update statement for the field myEntityid = Entityid when a new record is inserted in my featuretable.

If you then define a LPN (or Object data table) for this table which contains the field myEntityid, you can query this myentityid field (via vb or lisp) for knowing the Entityid Map uses.

Hope this can help you

Luc

[jordirov]

Hola jguzman_vtr,

creo que la api de Oracle Spatial no tiene su equivalente en ActiveX, sólo en C++, luego no puedes acceder a ella desde VB o Lisp.
Puedes probar de duplicar la columna Entityid a una columna, por ejemplo, de Object Data.

O utilizar VC++...

Jordi