Prev: Barcodes
Next: Quickest instring test
From: JD on 29 Jan 2010 09:30 Hi, When I make a filter, for example: LOCAL cKey AS STRING cKey := Upper(oDCsle:Value) obArrayServer:SetFilter ({| Server | Occurs(cKey,Upper(Server:Name)) > 0}) / / TRUE the filter is executed correctly and the browse is updated. Even so, when I press the arrow down or up and if exist records hidden betwewn the records shown, the filter is removed as if I had executed the command ClearFilter () Thank you.
From: Kevin on 29 Jan 2010 13:06 JD, Would it be because cKey is a local variable? If I remember correctly local variables cannot be used in codeblocks. Hope this helps. Kevin "JD" <jdhora(a)ig.com.br> wrote in message news:c3db223d-4cfe-47a0-a6a4-057a7f1509cc(a)k41g2000yqm.googlegroups.com: > Hi, > > When I make a filter, for example: > > LOCAL cKey AS STRING > > cKey := Upper(oDCsle:Value) > > obArrayServer:SetFilter ({| Server | Occurs(cKey,Upper(Server:Name)) > > 0}) / / TRUE > > the filter is executed correctly and the browse is updated. > > Even so, when I press the arrow down or up and if exist records hidden > betwewn the records shown, the filter is removed as if I had executed > the command ClearFilter () > > Thank you.
From: Massimo Bighelli on 29 Jan 2010 13:32 JD try the string version LOCAL cKey AS STRING LOCAL cFil AS STRING cKey := Upper(oDCsle:Value) cFil := "Occurs('"+cKey+"',Upper(Name)) > 0" obArrayServer:SetFilter (cFil) Massimo Bighelli www.arcasistemi.it
From: JD on 29 Jan 2010 15:11 Sorry, it didn't work.
From: JD on 29 Jan 2010 15:32
Which do work? |