Selection Processing Table Lookup

[Scott]

Sorry all 

Found It....

Thanks Bruce right track wrong place...

No the edit of my control record number edit was correct just a typo when I
retype for email ... but the edit of my month date should be md(7,mmyy) so
it was a edit fail only so there for the field was blanked and the whole
table wouldn't select any records....


Its always the last place you look.

Thanks All 

Scott

-----Original Message-----
From: filepro-list-bounces+scott.filepro=aanet.com.au at lists.celestial.com
[mailto:filepro-list-bounces+scott.filepro=aanet.com.au at lists.celestial.com]
On Behalf Of Bruce Easton
Sent: Wednesday, 14 March 2012 1:12 PM
To: filepro-list at lists.celestial.com
Subject: Re: Selection Processing Table Lookup

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/72b
e219f/attachment.html
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>

_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list