Re: TADODataset.Filter?


"Bill Todd" <no@xxxxxx> wrote in message
news:453a2ceb$1@xxxxxxxxxxxxxxxxxxxxxxxxx
If you are using a client-side cursor, which loads the entire result
set into local memory, then a filter may be faster.

--
Bill Todd (TeamB)

Thanks,

I have made some tests (and documentation searches)
but I cannot get filtering on partial text to work?

name = 'smith' returns all (and only) the records where
the field 'name' value is exactly 'smith' (or 'Smith'), but
name = 'sm*' (or name = "sm*") returns no records at all?

I have not been able to find and inspect the property
ADODataset1.FilterOptions in the object inspector, but
I have every reason to believe that it is empty, which
according to the help system is the default implying that
the asterisk is treated as a wildcharacter representing
any number of any characters.

At present I am stuck.

regards Sven


.

Relevant Pages

  • Re: TADODataset.Filter?
    ... set into local memory, then a filter may be faster. ... Bill Todd (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: Master / details
    ... Yes, however, I would not use a filter. ... parameterized SELECT to get the statistics you need. ... Bill Todd ... TeamB cannot answer questions received via email ...
    (borland.public.delphi.database.ado)
  • Re: TADODataset.Filter?
    ... The fact that you want to filter the dataset suggests that there are a ... why do you want to retrieve all of them ... Bill Todd (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: Capturing Raw Native 802.11 packets in Vista using ndislwf
    ... I suspect that there's something missing in the documentation - or perhaps something we have overlooked. ... For example, if I set the filter to 0, it ... native 802.11 packets should be from the filter driver... ...
    (microsoft.public.development.device.drivers)
  • Re: Thinking about upgrading to Solaris 10
    ... HP laser printers are everywhere. ... Just such a trivial filter can be found in the NetBSD documentation. ... convert UNIX files to those usable on Windose. ...
    (comp.unix.solaris)