topic Re: Scalar queries in File Geodatabase API Questions https://community.esri.com/t5/file-geodatabase-api-questions/scalar-queries/m-p/479249#M807 <HTML><HEAD></HEAD><BODY><SPAN>A </SPAN><A href="http://forums.arcgis.com/threads/60223-FGDB-API-not-respecting-Select-clause-of-SQL?p=210767&amp;viewfull=1#post210767">recent thread</A><SPAN> pretty much covered this -- ExecuteSQL is not complete.</SPAN><BR /><BR /><SPAN>- V</SPAN></BODY></HTML> Sat, 07 Jul 2012 21:38:14 GMT VinceAngelo 2012-07-07T21:38:14Z Scalar queries https://community.esri.com/t5/file-geodatabase-api-questions/scalar-queries/m-p/479248#M806 <HTML><HEAD></HEAD><BODY><SPAN>Hello, now i'm trying execute a scalar query:</SPAN><BR /><SPAN style="font-family:Courier New;">var queryRows = gdb.ExecuteSQL("SELECT COUNT(SAMPLE)&nbsp; FROM T_SAMPLES WHERE ID = 1");</SPAN><BR /><SPAN>And it returns a complete table T_SAMPLES.</SPAN><BR /><BR /><SPAN>My question, not it is possible make custom queries to tables of geodatabase?, or ExecuteSQL only works like filter of Tables??</SPAN><BR /><BR /><SPAN>Thank you.</SPAN></BODY></HTML> Wed, 04 Jul 2012 11:20:35 GMT https://community.esri.com/t5/file-geodatabase-api-questions/scalar-queries/m-p/479248#M806 RaúlFernández_de_Córdoba 2012-07-04T11:20:35Z Re: Scalar queries https://community.esri.com/t5/file-geodatabase-api-questions/scalar-queries/m-p/479249#M807 <HTML><HEAD></HEAD><BODY><SPAN>A </SPAN><A href="http://forums.arcgis.com/threads/60223-FGDB-API-not-respecting-Select-clause-of-SQL?p=210767&amp;viewfull=1#post210767">recent thread</A><SPAN> pretty much covered this -- ExecuteSQL is not complete.</SPAN><BR /><BR /><SPAN>- V</SPAN></BODY></HTML> Sat, 07 Jul 2012 21:38:14 GMT https://community.esri.com/t5/file-geodatabase-api-questions/scalar-queries/m-p/479249#M807 VinceAngelo 2012-07-07T21:38:14Z Re: Scalar queries https://community.esri.com/t5/file-geodatabase-api-questions/scalar-queries/m-p/479250#M808 <HTML><HEAD></HEAD><BODY><SPAN>The API is mostly based on 10.0. Scalar queries were not supported in the File Geodatabase until 10.1.</SPAN></BODY></HTML> Mon, 09 Jul 2012 15:58:12 GMT https://community.esri.com/t5/file-geodatabase-api-questions/scalar-queries/m-p/479250#M808 LanceShipman 2012-07-09T15:58:12Z