Ok. (he just pulls his foot from his mouth) It does walk. I was testing this
yesterday when I
couldn't get a choose with Type convesion function to work properly, so I used the
type Conversion
in a select to build a menu file on disk and forgot to turn headings off and ended up
with garbage
in the menu file and it didn't walk correctly. This morning I found the garbage and
removed it and
tried the file again, but (I know you will find this almost "Impossible To Believe") ,
I forgot to
set Walk on again. !:-o
So the workaround is:
Set Head Off
out test.mnu
wri '$MENU'
wri 'POPUP ||'
select ('|' + (ctxt((Float(Curramt)))) + '|' ) fro SomeTable wher SomeWhereClause
wri 'ENDC'
out scr
Set Head ON
cho vcho fro Test.mnu
ret
Using Float negates the need to mess with the Currency symbol.
Mike.
----- Original Message -----
From: "MikeB" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
Sent: Tuesday, September 16, 2003 9:07 AM
Subject: [RBASE-L] - Re: Walkmenu on currency values
> David,
> AFAIK, there is No Workaround. The Following menu doesn't Walk either.
>
> $MENU
> POPUP ||
> |312.01|
> |341.41|
> |112.96|
> |112.25|
> |0.|
> |341.41|
> |178.38|
> |112.96|
> |312.01|
> |178.38|
> |10000.|
> |248.37|
> |1900.|
> |47.82|
> |35.|
> |312.01|
> |341.41|
> |178.38|
> |112.96|
> |71.64|
> ENDC
>
> ----- Original Message -----
> From: "David M. Blocker" <[EMAIL PROTECTED]>
> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
> Sent: Tuesday, September 16, 2003 7:51 AM
> Subject: [RBASE-L] - Re: Walkmenu on currency values
>
>
> > I know that - I was just trying to give you a workaround. You could also
> > just eliminate the pound symbol altogether for the CHOOSE!
> >
> > David
> >
> > ----- Original Message -----
> > From: "Alastair Burr" <[EMAIL PROTECTED]>
> > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
> > Sent: Monday, September 15, 2003 2:47 PM
> > Subject: [RBASE-L] - Re: Walkmenu on currency values
> >
> >
> > > Whilst, obviously, it is possible to put the currency character at the end
> > > it is not "normal" - at least, in the UK.
> > >
> > > Regards,
> > > Alastair.
> > >
> > > (That's a comment not a criticism.)
> > >
> > >
> > > ----- Original Message -----
> > > From: "David M. Blocker" <[EMAIL PROTECTED]>
> > > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
> > > Sent: Monday, September 15, 2003 3:42 PM
> > > Subject: [RBASE-L] - Re: Walkmenu on currency values
> > >
> > >
> > > > Yes- it works with text but not with numbers and commas.
> > > >
> > > > Try these commands with CONCOMP:
> > > >
> > > > SET WALKMENU ON
> > > > choose vvalue from #values for Company from customer order by company
> > > lines
> > > > 20
> > > >
> > > > walkmenu works fine - try hitting MO and it jumps down to Modular
> > > Software,
> > > > Inc.
> > > >
> > > > Now try:
> > > >
> > > > choose vValue from #VALUES FOR (CTXT(NetAmount)) FROM Transmaster order
> > by
> > > > netamount lines 20
> > > >
> > > > Type "3,5" - instead of jumping to the first 3,590.00$ line it jumps to
> > > the
> > > > first 3,000 line when you hit 3, the next line when you hit comma, and
> > the
> > > > first 5,000 line when you hit 5.
> > > >
> > > > Razzak is this normal behavior or it is a boo-boo I should submit?
> > > >
> > > > David Blocker
> > > >
> > > > ----- Original Message -----
> > > > From: "Javier Valencia" <[EMAIL PROTECTED]>
> > > > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
> > > > Sent: Monday, September 15, 2003 9:53 AM
> > > > Subject: [RBASE-L] - Re: Walkmenu on currency values
> > > >
> > > >
> > > > > David:
> > > > > Did you have "SET WALKMENU ON"?
> > > > > Javier,
> > > > >
> > > > > Javier Valencia, PE
> > > > > President
> > > > > Valencia Technology Group, L.L.C.
> > > > > 14315 S. Twilight Ln, Suite #14
> > > > > Olathe, Kansas 66962-4578
> > > > > Office (913)829-0888
> > > > > Fax (913)649-2904
> > > > > Cell (913)915-3137
> > > > >
> > > > > -----Original Message-----
> > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David
> > M.
> > > > > Blocker
> > > > > Sent: Monday, September 15, 2003 8:44 AM
> > > > > To: RBASE-L Mailing List
> > > > > Subject: [RBASE-L] - Re: Walkmenu on currency values
> > > > >
> > > > > Suppose the column in question is PoundValue
> > > > >
> > > > > Try this:
> > > > >
> > > > > SET CURRENCY '�' SUFF 2B
> > > > > CHOOSE vvalue from #VALUES FOR (CTXT('PoundValue')) FROM table....
> > ORDER
> > > > BY
> > > > > PoundValue
> > > > > SET CURRENCY '�' PREF 2B
> > > > >
> > > > > This would put the pound symbol AFTER the values, and display as text,
> > > but
> > > > > in order by the amount. I tried it with CONCOMP in 7.0; I could press
> > 3
> > > > to
> > > > > jump to the first starting with 3, but couldn't press 3,5 to go to
> > > 3,500.
> > > > >
> > > > > It's close, but still not real walkmenu.
> > > > >
> > > > > David Blocke
> > > > >
> > > > > David
> > > > >
> > > > > ----- Original Message -----
> > > > > From: "MikeB" <[EMAIL PROTECTED]>
> > > > > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
> > > > > Sent: Sunday, September 14, 2003 7:39 PM
> > > > > Subject: [RBASE-L] - Re: Walkmenu on currency values
> > > > >
> > > > >
> > > > > > Walkmenu apparently only works on columns of type text. I tried it
> > on
> > > > Int
> > > > > and Curr and it doesn't
> > > > > > work which is no surprise if you think about it.
> > > > > >
> > > > > >
> > > > > > ----- Original Message -----
> > > > > > From: "Alastair Burr" <[EMAIL PROTECTED]>
> > > > > > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
> > > > > > Sent: Sunday, September 14, 2003 5:08 PM
> > > > > > Subject: [RBASE-L] - Walkmenu on currency values
> > > > > >
> > > > > >
> > > > > > > Has anybody a method for "walking through a menu" of currency
> > > values?
> > > > > > >
> > > > > > > My form with a pop-up menu shows the currency symbol (� in my
> > case -
> > > > > pounds
> > > > > > > sterling if that gets converted by the e-mail system) and then the
> > > > > value.
> > > > > > > Typing the symbol does nothing and I can't get to the values.
> > > > > > >
> > > > > > >
> > > > > > > Regards,
> > > > > > > Alastair.
> > > > > > >
> > > > > > > ----------------------------------
> > > > > > > A D B Burr,
> > > > > > > St. Albans, UK.
> > > > > > > ----------------------------------
> > > > > > > [EMAIL PROTECTED]
> > > > > > > ----------------------------------
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > >
> > >
> >
> >
>
>