Re: Can't use '*' in TADODataset.Filter




When I set Filter property :

tblProduct.Filter := 'Name=''*' + edName.Text + '*''';
tblProduct.Filtered := True;

it's not work.

can anyone recomment me?

What database are you using?
Wild card characters are dependent on the database you use.
Access under ADO uses "%" character as a multi character wild card
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.



Relevant Pages

  • Re: Loading a data file containing character fields with different encodings
    ... UTF-8 characters along with Latin-1 characters. ... One containing the latin-1 character set column, the second containing the utf-8 column and of course both files containing the primary key information. ... it would be just as easy to write the loader script that converts the encoding to a "unicode" intermediate format and then load with the correct database encoding. ... This caused that no conversion was done, but you were puting CP1252 characters into an 819 database! ...
    (comp.databases.informix)
  • Re: Are there performancebenefits to reorganizing database-using export/import?
    ... time we had done full export of 8.1.7 database and then created 9.2. ... those warnings are well defined in "Expert Oracle Database ... What happens if you accidentally change the character set when you ... exactly 30 characters long with an empty set character in the column ...
    (comp.databases.oracle.server)
  • Re: help needed
    ... Whether you use pointer arithmetic or array notation, set up the database to look like a two-dimensional array of chars; ... Get the first character of the database entry. ... Of it is NULL go on to the next database entry. ... a NULL password will pass unless all database entries contain valid passwords. ...
    (comp.dsp)
  • Re: JSP Internationalization
    ... fixed it for me was to make sure that my Oracle database was in the ... correct character set, Oracle 9i did not use the standard UTF-8 unless ... I still get question marks. ... The native resource file is saved as UTF 8. ...
    (comp.lang.java.programmer)
  • Re: Syntax Problem
    ... If we can identify the specific character that is the delimiter for the ... Can you copy and paste the special delimiter character into a newsgroup post ... >> Oae is the extension requested by the College Board of Examiners in New ... >>> The Database Name argument is the database you are exporting to. ...
    (microsoft.public.access.macros)