Sql problem containing a " ' "

[Pietjeparasietje]

Hi,

I'm using the following sql statement to get a rate for a
customer. " Select * from rates where CustomerName = '''+CustomerNameStr+'''';

This statement works fine but not when I've got a customere name like this "Dinico's" the "'" is interfearing. Does anyone know how to solve this.

help is very appreciated!
Peter

 

[lespaul]

try this:

Select * from rates where CustomerName = ' + QuotedStr(CustomerNameStr);

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

 

[LucieLastic]

Hi

In a select, quotedstr should handle an apostrophe.

Select * from rates where CustomerName = '+
Quotedstr(CustomerNameStr);

If there's still a problem with what comes back, the problem may have occurred on the insert or update, as you need to double up single apostropies - that is, you need to replace 1 apostrophy with 2 apostrophies when doing.

lou

 

[Pietjeparasietje]

Thanx guys, couldn't find that anywhere! this helps a lot!
Peter

 

[Nordlund]

You can use a query with parameters as well

SQL.Add('SELECT * FROM rates where CustomerName = :Customer');
ParamByName('Customer').AsString := sCust;

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
There is always another way to solve it, but I prefer my way.