Scalar queries

[RaúlFernández_de_Córdoba]

Hello, now i'm trying execute a scalar query:
var queryRows = gdb.ExecuteSQL("SELECT COUNT(SAMPLE)  FROM T_SAMPLES WHERE ID = 1");
And it returns a complete table T_SAMPLES.

My question, not it is possible make custom queries to tables of geodatabase?, or ExecuteSQL only works like filter of Tables??

Thank you.

[VinceAngelo]

A recent thread pretty much covered this -- ExecuteSQL is not complete.

- V

[LanceShipman]

The API is mostly based on 10.0. Scalar queries were not supported in the File Geodatabase until 10.1.