[es] - Pretrazivanje BAZE

00000110001

Član broj: 22138
Poruke: 38
*.ben.tuwien.ac.at.

Profil

^{18.05.2005. u 10:45 - pre 230 meseci}

PROBLEM GLASI:
Koristim LAZARUS, i kreirao sam bazu i napunio podacima.
Sad kad zelim da pretrazujem bazu stvara se problem. Koristio sam komandu LOCATE, ali ona mi ne radi pa me interesuje da li je to do LAZARUSA ili ja pravim gresku, kod glasi:
Dbf1.Locate('IME','AAAA',[]);

Pokusao sam i sa filtriranjem ali sam naisao na neki drugi problem.
Kad hocu da isfiltriram bazu po npr. POLJU "IME" koje sadrzi: "AAA 15" ; "AAA 15L" ; itd.
Kod glasi;
Filter('IME="AAA 15"');
kao rezultat dobijem i "AAA 15" i "AAA 15L" slog, zasto oba sloga a ne jedan, ipak se oni razlikuju u jednom slovu, isto se desava kad postavim filter kao:
Filter('IME="AAA 15L"');

Bilo kakav odgovor i ideja su dobrodosli.
Unaprijed zahvaljujem.

Odgovor na temu

morlic
Milos Orlic
Beograd

Član broj: 6081
Poruke: 735
*.84.EUnet.yu.

+1 Profil

Re: Pretrazivanje BAZE - LAZARUS

^{19.05.2005. u 23:02 - pre 230 meseci}

Izgleda da niko ne koristi LAZARUS ;)

Delphi kaze za Locate:

Citat:

Syntax

[Delphi] public function Locate(const KeyFields: string, var KeyValues: Variant, Options: TLocateOptions): Boolean;

Description
This function:
Checks whether the dataset is unidirectional, and if so, raises an EDatabaseError exception.

Returns false, indicating that a matching record was not found and the active record was not changed.

Descendant classes that are not unidirectional override this method so that it locates the record where the fields identified by the semicolon-separated list of fields in KeyFields have the values specified by the Variant or Variant array KeyValues. Options indicates whether the search is case insensitive and whether partial matches are supported. Locate returns true if a record is found that matches the specified criteria and that record is now active.

Odgovor na temu