Table Filter variable with apostrophe

[JamesC]

How do I TableFilter using a variable if the variable contains an apostrophe?

e.g. x="l'ami"

table1.filter("Name = '" & x & "'") will throw up an error, while it will work for variables that don't contain an apostrophe.

Thanks

James

 

[Erel]

I don't think that it is possible.
You can try to use Like instead:
"Name LIKE '*ami'"

 

[JamesC]

Ta

Thanks Erel, that's what I thought. I'll rewrite my filter code to check for apostrophes.

What do you think - perhaps it would be a good idea to have a filter command that just dealt with variables, as I imagine this is how it is often used? At present, using different syntax for numbers and strings makes it a little more complex - but perhaps that is just my application, which has a one button filter of the selected column by the contents of the selected cell. I need different syntax depending on whether the column holds numbers or strings. Which is not too difficult. But then adding code to look for apostrophes!!!

Best regards!

 

[Erel]

If you treat numbers as strings then you can use cString columns instead of cNumbers.

 

[BPak]

You could try substituting the ' with an underline _
in the string and then do the LIKE 'sqlite_'

In the SQL i Use in C I can use either the Underline or the % as a substitue for any char in the LIKE String. SQLite should be able to use this.

 

[digitaldon37]

Would using double quotes for the query instead of single quotes work?

table1.filter("Name = " & chr(34) & x & chr(34) & "")