Good idea!
BUT it doesn't work in all situations on my end with this command:
Try this in CONCOMP:
SET WALKMENU ON
choose vvalue from #values for (ctxt(float(NetAmount))) from transmaster
order by netamount lines 20
It seems that on the FIRST try the walkmenu works. But if you change no
settings and repeat the command, walkmenu no longer works, even though it's
on
It's fine with text, but not with numbers.
Can you confirm?
David Blocker
----- Original Message -----
From: "MikeB" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
Sent: Tuesday, September 16, 2003 10:29 AM
Subject: [RBASE-L] - Re: Walkmenu on currency values
> 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]
> > > > > > > > ----------------------------------
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
