StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Business Issue Filter Issue

Business Issue Filter Issue

Danny Doobay — Sat, 07 Jun 2014 13:36:50 GMT

Hello,

When I have to filter BO, this code works fine until First Name has a single quote (For example o'reilly)

CustomerBO.Filter = "FirstName = '" & First_Name & "'"

What is the alternative?

Danny Doobay — Sat, 07 Jun 2014 13:36:50 GMT

Thank you.

Edhy Rijo — Thu, 05 Jun 2014 22:12:12 GMT

Hi Danny,

Use the String.Format instead to set your filter condition, it is cleaner and work all the time.

CustomerBO.Filter = String.Format("First_Name = {0}", First_Name)

Danny Doobay — Thu, 05 Jun 2014 16:07:17 GMT

I found the answer:

First_Name.Trim.Replace("'", "''")

replace single quote with two single quote.