topic SQL syntax in query filter interface in ArcObjects SDK Questions

SQL syntax in query filter interface

RadekHýbner — Sun, 25 Apr 2010 10:03:40 GMT

Hi
I am writing some tool in ArcGIS desktop 9.3 in VBA and I need to extract data in table by query filter interface.
I have data in personal db and
pQf.WhereClause = "TextString <> Null"
is OK. But when I have data in File db theres a problem. I know that there is syntax a little different... but I can not find correct version.
Thanks.

SQL syntax in query filter interface

StefanOffermann — Mon, 26 Apr 2010 04:19:52 GMT

For File Geodatabase, you have to enquote field names with double quotes:

"Field" = 'Value'

see: http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?TopicName=SQL_reference

regards, Stefan

SQL syntax in query filter interface

RadekHýbner — Mon, 26 Apr 2010 06:41:16 GMT

thanks for reply.
but I tried this before and it writes me that it is not correct...

SQL syntax in query filter interface

StefanOffermann — Tue, 27 Apr 2010 07:03:43 GMT

Then you have an error in your code. The double quotes are the right way. I don't know the exact way in VBA to escape the double quotes, in C# I would write:

pQf.WhereClause = "\"FieldName\" <> Null"

You should check how to use

<>

and

Null

in VBA.

Query for NULL

JohnHauck — Tue, 27 Apr 2010 15:45:37 GMT

You can use the following for either File or Personal geodatabase:

pQF.WhereClause = "YourFieldName IS NOT NULL"

Re: SQL syntax in query filter interface

RadekHýbner — Fri, 07 May 2010 07:50:07 GMT

correct is
pQF.WhereClause = "YourFieldName IS NOT NULL"
thanks