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