AnsweredAssumed Answered

WhereClause Street name , House number, Postal code

Question asked by siggisal on Oct 16, 2017
Latest reply on Oct 16, 2017 by siggisal

Hi

 

I have 3 Textbox and I need to search for Street name , House number, Postal code

House Number and Postal code  can be empty

I am try to search using just part of street name or full name

Street name = Data Type Text

House number = Data Type Numeric

Postal code = Data Type Numeric

 

I can search for street name with House number but if I have no House number I get nothing

 

 

 pQueryFilter.WhereClause = "Street = '" + Street.Text + "' AND Number = '" + number.Text + "'"

Outcomes