Selection Processing Table Lookup

[Bruce Easton]

Scott,

Is the edit for br actually coded as "br (2,.0)" or as you have it typed 
here (2.0)?  I tried that type of edit (the way you have it here) under 
5.014 and surprisingly passed syntax check and let me assign a value of 
1 to br (although not as a 2-digit integer).

Also, are you by any chance calling this report with a file qualifier, 
as in '... -m <qualname>'?
If so, then your lookup here would also assume that qualifier (so if 
that's not what is intended, you would need an "balances@" as the 
filename below).

Other than the code looks ok.  Well, I am assuming that this control 
record #1 in balances is a permanent record in the database and not 
something with which the application can perform magic.

Bruce

On 3/13/12 10:44 PM, Scott wrote:
> Hello all
>
>
>
> Can sort/select table do a LOOKUP?
>
>
>
> With a processing table run with -v name do a lookup to obtain other
> selection data from another table!
>
>
>
>
>
> Processing_tables: vtable
>
>           If: aa eq  ""
>         Then:  br (2.0) = "1"
>
>           If: aa eq  ""
>         Then:  LOOKUP balances r=br -e
>
>           If: aa eq  ""
>         Then:  md (6,mmyy) = balances(24) ; SHOW " Current Month is :-" { md
>
>          If: aa eq  ""
>         Then:  close balances
>
>           If: aa eq  ""
>         Then: input cp(1,yesno,g) "Do you want the Current Processing Month
> ?"
>             If: aa eq   ""  and cp eq "Y"
>
>         Then: aa (1,.0,g) = "1"; cu = cp
>
>            If: aa eq   ""  and cp eq "N"
>
>         Then: input cu(6,mmyy,g) "What Month do you want?  "
>           If: aa = ""
>         Then: aa = "1"
>
>           If: 1 eq cu
>
>         Then: select
>
>           If:
>         Then: end
>
>
>
> Yet in debug . LOOKUP has not been performed .
>
>
>
>
>
>
>
>
>
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20120314/72be219f/attachment.html
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>