Talk About Network



Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Programming > Clipper > Re: TBrowse wit...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 10 of 13 Topic 3847 of 3903
Post > Topic >>

Re: TBrowse with Filter

by "AUGE_OHR" <AUGE_OHR*NOSPAM@[EMAIL PROTECTED] > Feb 26, 2008 at 09:05 PM

hi,

> set scope to { || Str(vAdNr,6) }
>
> SET FILTER TO (LIEFER->SR_NR == 0 .or. LIEFER->SR_NR == vSrNr) .and. 
> LIEFER->BETRAG # 0 .and. !LIEFER->BEZAHLT
>
> LIEFER->(DbGoTop())
> LIEFER->(DbSeek(Str(vAdNr,6)))

you can try to get Parts of your "Filter" into Index Expression e.g.
*** snip ***
index on 
Str(_FIELD->ADR_NR,6)+IF(LIEFER->BEZAHLT,"J","N")+Descend(Str(_FIELD->LS_NR,6))

tag LIEFADR

cSeek := Str(vAdNr,6)+"N"
SEEK(cSeek)
IF FOUND()
    set scope to (cSeek)
    set filter to XXX
*** eof ***
greetings by OHR
Jimmy




 13 Posts in Topic:
TBrowse with Filter
otto <ohaldi@[EMAIL PR  2008-02-22 10:20:48 
Re: TBrowse with Filter
"N:dlzc D:aol T:com   2008-02-22 06:02:52 
Re: TBrowse with Filter
otto <ohaldi@[EMAIL PR  2008-02-22 19:56:58 
Re: TBrowse with Filter
"Stephen Quinn"  2008-02-22 23:40:59 
Re: TBrowse with Filter
otto <ohaldi@[EMAIL PR  2008-02-23 12:16:41 
Re: TBrowse with Filter
"Stephen Quinn"  2008-02-24 02:26:08 
Re: TBrowse with Filter
otto <ohaldi@[EMAIL PR  2008-02-25 21:03:13 
Re: TBrowse with Filter
"Stephen Quinn"  2008-02-26 01:48:02 
Re: TBrowse with Filter
otto <ohaldi@[EMAIL PR  2008-02-26 19:57:47 
Re: TBrowse with Filter
"AUGE_OHR" <  2008-02-26 21:05:36 
Re: TBrowse with Filter
otto <ohaldi@[EMAIL PR  2008-02-27 12:47:52 
Re: TBrowse with Filter
"Stephen Quinn"  2008-02-27 01:25:46 
Re: TBrowse with Filter
otto <ohaldi@[EMAIL PR  2008-02-27 12:46:39 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri May 16 10:14:43 CDT 2008.