Busqueda en un DBgrid

[[nlsgarcia]]

feliz-58,

Revisa esta información:

Empezado por Borland Delphi 6 Developer's Guide:

"function Locate(const KeyFields: string; const KeyValues: Variant;
Options: TLocateOptions): Boolean;

The first parameter, KeyFields, contains the name of the field(s) on which you want to search.
The second parameter, KeyValues, holds the field value(s) you want to locate. The third and
last parameter, Options, allows you to customize the type of search you want to perform. This
parameter is of type TLocateOptions, which is a set type defined in the DB unit as follows:

type
TLocateOption = (loCaseInsensitive, loPartialKey);
TLocateOptions = set of TLocateOption;

If the set includes the loCaseInsensitive member, a not case sensitive search of the data will
be performed. If the set includes the loPartialKey member, the values contained in KeyValues
will match even if they’re substrings of the field value."

En resumen:

Código Delphi [-]
ADOTable1.Locate ('Nombre', edit1.text,[loCaseInsensitive,loPartialKey]);

El código anterior hará búsquedas en el DataSet sin distinción entre minúsculas y mayúsculas y con valores parciales.

Espero sea útil

Nelson.