Hi to all,
i have a layer on arcsde (SQL 2008 R2) and a service who map this layer. I have also a query task with where clausole.
if i would like to make an order by i have an error ( arcmap has the same problem ). This not happens if the service map a layer on file geodatabase. the where clausole i have used is "1=1 order by myfield", I have tried to do this also whith syntax from sql server 2008
databasename.dbo.layername.fieldname
If where clausole not specified all works good, but i need to apply a order by on field.
That's right ? is a correct behaviour of arcsde layer or there's a way tio do this anyway ?
Thanks very very much
GP