Event theme based on non-numeric fields

Question

Hi

We have a third party application with data stored in Oracle.  There is a table with text fields for east/north.

We want to create an Event Layer.  We cannot modify the table and as it is 3rd party don't want to add an Oracle view as it may mess with the support.

So, anyone any ideas if it is possible to cast/convert text fields within Desktop to create an event theme?

Cheers

ACM

adrian.marsden_DevonCC · Answer

I thought as much - we think we'll warehouse the data in SQL and do the conversion there. We don't like messing around in Oracle.

Thanks

DanPatterson_Retired · Answer

you would have to add two new double fields and cast any text representations of numbers using 'float'.  You can't create an event theme directly from text, so you will have to edit the original file, add the fields or perform the operation on a new file