Difficulty with Query filter WhereClause using different fields

deleted-user-h2MwrUDd3vgt — Thu, 22 Jul 2010 19:48:56 GMT

I'm trying to create a query filter in order to guarantee that a user doesn't use the same value twice but am having difficulty creating a WhereClause that evaluates two different fields. I'm able to get it to work using one field, but when I add the second clause I get the following compile error:

Type-declaration character does not match declared data type.

I would appreciate any ideas as to how to fix this error, or any suggestions as to how I could accomplish the same task a different way.

Thanks!

Public Sub DuplicateEntry()

Dim pMxDoc As IMxDocument
Dim pMap As IMap
Set pMxDoc = ThisDocument
Set pMap = pMxDoc.FocusMap
Dim pFLayer As IFeatureLayer
Set pFLayer = pMap.Layer(0)
Dim pFClass As IFeatureClass
Set pFClass = pFLayer.FeatureClass


' query filter to test to see if the input value already exists
Dim pQf As IQueryFilter
Set pQf = New QueryFilter
pQf.WhereClause = "PHOTO_NO = " & frmRamp.txtPhoto.Text& And "WARD =" & frmRamp.txtWard.Text&

' if it exists show message
If pFClass.FeatureCount(pQf) > 0 Then
MsgBox "Value already exists, try again!", vbOKOnly, "Forum Help"
frmRamp.Hide
frmRamp.Show

Exit Sub
End If



End Sub

Re: Difficulty with Query filter WhereClause using different fields

KenBuja — Thu, 22 Jul 2010 20:35:11 GMT

You have your quotes in the wrong place. Try this for your whereclause:

pQf.WhereClause = "PHOTO_NO = " & frmRamp.txtPhoto.Text & " And WARD =" & frmRamp.txtWard.Text

Re: Difficulty with Query filter WhereClause using different fields

deleted-user-h2MwrUDd3vgt — Thu, 22 Jul 2010 21:06:42 GMT

That did it, thanks a ton! I think I tried every variation trying to get this thing to work.

topic Re: Difficulty with Query filter WhereClause using different fields in ArcObjects SDK Questions

Difficulty with Query filter WhereClause using different fields

Re: Difficulty with Query filter WhereClause using different fields

Re: Difficulty with Query filter WhereClause using different fields