It's a long time since I did this:-
sNew is a string variable that may contain a "'" character.

But I always get a result with no records.

No doubt I'm missing something obvious but any ideas would be welcome

I hate this quoting problem. It comes up from time to time and I never seem to remember what I did last time.

In an example where I was running a Gimp script I did this:-


So you may need to build the contents of sNew using Quote(sSomething) for the quoted part. Can we see an example of contents of sNew?

Exactly!
Here is the offending string:-

OK, so it looks like your quoting problem is with SQL not Gambas (i.e. you need to quote to suit SQL rules).

Take a look at this post and let us know if it helps: SQL to Query text in access with an apostrophe in it - Stack Overflow

Ah yes!
The problem was with a record in the db that contained a single (').
Using Gambas Replace function in the SQL statement solves the problem.

Thanks for the help.

You can use this: /comp/gb.db/_connection/quote - Gambas Documentation

I think there's a bind parameters, or something like that too, or I'm confusing with PHP