Am trying to retrieve an entry in a table (Oracle then SDE) that has a maximum value in one of it's fields but cannot get it right:
query.where = "OBJECTID=(SELECT MAX(OBJECTID) FROM TABLE_NAME)";
fails.
Is this functionality supported in the flex api (the equivilent call works from the service's query form) or have I just got the syntax wrong?
Thanks
Martyn
