Subject | Re: [IBO] Filter |
---|---|
Author | Helen Borrie |
Post date | 2007-09-19T14:16:19Z |
At 11:54 PM 19/09/2007, you wrote:
with the qualifier correction.
So - apply the filter as
upper ( cli.NOME) LIKE 'TIAGO%'
You haven't said HOW you are applying the filter. Remember, it is a
string, so you need to take care of embedded quotes. So, if it's in
code and you are hard-coding the LIKE operand, you'll need to do e.g.
MyDataset.Filter := QuotedStr('upper ( cli.NOME) LIKE 'TIAGO%');
Helen
>Hi, here goes the original SQL (with monitor output), after I apliedI meant, apply the original filter (without the extra parens) but
>the filter:
with the qualifier correction.
So - apply the filter as
upper ( cli.NOME) LIKE 'TIAGO%'
You haven't said HOW you are applying the filter. Remember, it is a
string, so you need to take care of embedded quotes. So, if it's in
code and you are hard-coding the LIKE operand, you'll need to do e.g.
MyDataset.Filter := QuotedStr('upper ( cli.NOME) LIKE 'TIAGO%');
Helen