SQLserver, zeos and Filter = empty?
lazarus / 16-Databases

----------------------------------------------------------------------
cpalx · 2009-02-05 19:29

hello
i have a sqlserver conecction with zeos.
i use a ztable component (with a dbgrid), it shows the records, when i
try to filter using this code :

   Ztable.Filtered:=false;
   Ztable.Filter:= ' AFiled like  ' +  QuotedStr( edit.Text + '%');
   Ztable.Filtered:=true;

the result is always empty.
I use Lazarus 0.9.26-1  with fpc 2.2.2 in Windows XP-SP3

Any idea?

----------------------------------------------------------------------
cpalx · 2009-02-05 19:34

the solution, it works like

   Ztable.Filtered:=false;
   Ztable.Filter:= ' AFiled like  ' +  QuotedStr( edit.Text + '*');
   Ztable.Filtered:=true;

the comodin is *, is not %