browse lookup

GCC Consulting rkreiss at gccconsulting.net
Thu Jan 12 08:45:56 PST 2012


I am having difficulty getting a browse lookup . I need to highlight items which are unpaid.

In the record field(33) will  be 6 or greater if it is a closed item.

Windows filepro 5.6.10

400  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ◄ If:
       Then: aa="(brw=12 xkey=xc show=pkeep prc=do_hilt fill=desc,top)"
401  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ◄ If:
       Then: AB="[\b5     SJ #  Due Date   Ex Date   tp    Amount     Paid     Status   Cancel  \a-"
402  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ◄ If:
       Then: AC=""{zc<"1      *7         *8        *6   *9        *40       *33   *68"<zf
403  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ◄ If:
       Then: SHOW POPUP("3","-1") "Select Transactions for Cancellation"
404  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ◄ If:
       Then: SHOW POPUP("18","-1") "Press \b4 C \a-Cancel Transaction, \kZ- Finish, \r X \r-Exit No Cancel"
405  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
do_tran◄ If:
       Then: Lookup tran = transaction  k=16   i=E -Nx
406  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ◄ If:         NOT tran
       Then:        BEEP;MSGBOX "No Transaction Found";GOTO cnt_opn
407  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ◄ If:
       Then: lookup tran = transaction  k=16   i=E -Nxm b=(AA&AB&AC)
408  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ◄ If:         @sk = "BRKY"
       Then:         DontCancel="N";GOTO chk_can
409  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ◄ If:         @bk = "X" or @sk = "BRKY"
       Then:         CLEARB;CLEARS;DontCancel="N";GOTO cnt_opn
410  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ◄ If:         @bk = "C" and tran(68) = "" and tran(33) lt "6"
       Then:         TranStat=Tran(33);Tran(33)="9";Tran(68)=CancelDate;GOTO do_tran
411  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ◄ If:         @bk = "C" and tran(68) = CancelDate                       ◄
       Then:         Tran(33)=TranStat;Tran(68)="";GOTO do_tran                ◄
412  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ◄ If:                                                                   ◄
       Then: CLEARB;CLEARS;DontCancel="";GOTO cnt_opn                          ◄
413  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
do_hilt◄ If: '**************************************************************   ◄
       Then: '*                                                                ◄
414  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ◄ If:                                                                   ◄
       Then: debug on                                                          ◄
415  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ◄ If: tran(33) lt "6" or tran(33) = ""                                  ◄
       Then: zc="\b5";zf="\a-";end                                             ◄
416  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ◄ If: tran(33) ge "6"                                                   ◄
       Then: zc="";zf=""                                                       ◄
417  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ◄ If:
       Then: END

If I change line 402 to:
402  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ◄ If:                                                                   ◄
       Then: AC="*zc *1      *7         *8        *6   *9        *40       *33    *68            *zf"

The line is highlighted but everything is shifted left.
Why is the highlight no working when the value of zc is set AC=""{zc<"?


Richard Kreiss
GCC Consulting

Office: 410-653-2813









More information about the Filepro-list mailing list