topic Re: Selecting by Attributes using "MID": Personal GDB vs SDE in Data Management Questions

Selecting by Attributes using "MID": Personal GDB vs SDE

ScottGowan — Thu, 08 Dec 2011 15:39:50 GMT

Greetings all,

Within ArcMAP using a feature class in a personal GDB, I originally used this query for selecting from a text field using the "select by attributes" tool and it work correctly:

MID (StationRunOrder,1,1) = "4" OR MID (StationRunOrder,3,1) = "4"

Running the same query on this features class after it was imported to SDE the same query returns the error:

There was an error with expression. Underlying DBMS error[ORA-0094: "4": invalid identifier]

The fields I'm selecting from are defined the same in both cases. I suspect it's simply a syntax issue. Any help would be greatly appreciated.

Regards,

Scott

Re: Selecting by Attributes using "MID": Personal GDB vs SDE

VinceAngelo — Thu, 08 Dec 2011 17:01:40 GMT

What does "MID()" do? You need to use the equivalent Oracle SQL function.

- V

Re: Selecting by Attributes using "MID": Personal GDB vs SDE

ScottGowan — Thu, 08 Dec 2011 19:08:15 GMT

What does "MID()" do? You need to use the equivalent Oracle SQL function.

- V

You were right on.

The equivalent in Oracle is substr (sub string). I'm pulling out values from the string in the first three postions when they're '?', which ever value I want. '7' in this case.

The revised query was:
substr (StationRunOrder,1,1) = '7' OR substr (StationRunOrder,3,1) = '7'

Thanks. Scott