Tim

Another little issue.

There is a table with a field called FLG and some records were populated
with *

If I call SQL statement SELECT * FROM TABLE WHERE FLG='*', it works as
expected but if I apply a filter FLG='*' on a table it does not work.

Eduardo

Jose Eduardo Helminsky wrote:
> Tim
>
> Another little issue.
>
> There is a table with a field called FLG and some records were
> populated with *
>
> If I call SQL statement SELECT * FROM TABLE WHERE FLG='*', it works as
> expected but if I apply a filter FLG='*' on a table it does not work.

Please explain "does not work". Do you get all records or no records at all?
Did you set Filtered to True?

Ralf

Jose


Somewhere at the back of my mind is a memory that * in a filter is a wildcard like DOS

Roy Lambert

Ralf

> Please explain "does not work". Do you get all records or no records at
> all?
"Does not work" means, I get *ALL* records instead of only records with '*'.

> Did you set Filtered to True?
Yes

Eduardo

Roy

> Somewhere at the back of my mind is a memory that * in a filter is a
> wildcard like DOS
It can be my mistake using * as a field content but if this is a wildcard,
it is not documented.

Eduardo

Jose Eduardo Helminsky wrote:
....
> It can be my mistake using * as a field content but if this is a
> wildcard, it is not documented.

It is, see "Setting Filters on Tables and Query Result Sets" in the help
file. You have to add foNoPartialCompare to the FilterOptions to get the
behaviour you want.

Ralf

Ralf

Ok, I´ve checked the help and found this issue.

Thanks for your help

Eduardo

"Ralf Mimoun" <nospam@rad-on.de> escreveu na mensagem
news:142A64CD-F3B8-4D66-9095-FA8CB2D27634@news.elevatesoft.com...
> Jose Eduardo Helminsky wrote:
> ...
>> It can be my mistake using * as a field content but if this is a
>> wildcard, it is not documented.
>
> It is, see "Setting Filters on Tables and Query Result Sets" in the help
> file. You have to add foNoPartialCompare to the FilterOptions to get the
> behaviour you want.
>
> Ralf

Eduardo,

<< There is a table with a field called FLG and some records were populated
with *

If I call SQL statement SELECT * FROM TABLE WHERE FLG='*', it works as
expected but if I apply a filter FLG='*' on a table it does not work. >>

Include the foNoPartialMatch filter option in the FilterOptions property.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

> Include the foNoPartialMatch filter option in the FilterOptions property.
Got it

Thanks
Eduardo