That is not what I said. The embedded Type conversion function in the Choose command
won't work.
But If you create a menu file on disk using the type conversion it will... but Add an
Order by
NetAmount to the select and It doesn't seem to work and even though it does work in an
unordered
sequence, the keypresses seem a bit quirky??
Set Head Off
Set Walkmenu ON
out test.mnu
wri '$MENU'
wri 'POPUP ||'
select ('|' + ((ctxt(float(NetAmount)))) + '|' ) from transmaster
wri 'ENDC'
out scr
Set Head ON
cho vcho fro Test.mnu
ret
----- Original Message -----
From: "David M. Blocker" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
Sent: Tuesday, September 16, 2003 10:54 AM
Subject: [RBASE-L] - Re: Walkmenu on currency values
> 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]
> > > > > > > > > ----------------------------------
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
