SQL syntax in query filter interface

[RadekHýbner]

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.

[StefanOffermann]

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

[RadekHýbner]

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

[StefanOffermann]

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.

[JohnHauck]

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

pQF.WhereClause = "YourFieldName IS NOT NULL"

[RadekHýbner]

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