Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Colums without index on database don't search.
Thu, Jul 25 2013 11:16 PMPermanent Link

Amaury López

ASESYS

Why  colums without index on database don't search.

I use this code:

function buscar(valor,campo:string; tabla:tdataset):boolean;
begin
  with tabla do
  begin
     Columns[campo].SortDirection:=sdAscending;
     SortCaseInsensitive:=True;
     Sort;
     tabla.InitFind;
     tabla.COLUMNS[campo].AsString:=valor;
     if tabla.Find(False{NearestMatch},True{CaseInsensitive}) then
     begin
        Result:=True;
     end
     else
        Result:=False;
   end;
end;

Only result true on index colums.
Wed, Jul 31 2013 12:55 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Amaury,

Sorry for the delay in getting a response to you on this.

<< colums without index on database don't search. >>

I'm not seeing this here - case-insensitive searches seem to work just fine.

Can you send me a small project that reproduces the issue ?

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com
Image