Hi,
I want to query features from Oracle Spatial using predefined where-clauses.
Is it possible to write a macro with a where-clause in it, to query only a subset of the feature from the oracle spatial datastore?
Where can i find a api to use the functionality of the oracle spatial modul?
Thanks for help,
Stefan.
Hi. If the where clauses are predefined and there aren't many of them you could consider creating views in your database and querying those views directly. This would save you from needing to write code.
Alternately you could create your import criterias manually using the user interface and save them in separate .orax files that you would later use from GDI keyins.
If none of these options are viable you can have a look at the developer reference guide bundled in Bentley Map SS2. Specifically look at GeoDataInterchangeAPI.
Martin
Hi Martin,
thanks for your advice.
I did not know that you can save your criteria settings in the orax file.
By chance, you know the correct keyin syntax to call that orax files. I couldn't examine that by running the macro recorder...
And unfortunately I am forced to use the SS1.
Thanks, Stefan.
I think it is "GDI CONNECT file=oraxfile password=passvalue".
Check the Bentley Map documentation and od a search for "GDI". You should find all related keyins.
Thanks for your help, but unfortunately the ss1 still lacks the gdi connect commands. In ss2 you can use it, the documentation says.