Mike
I concur
We have TWO separate booboos.
1. CHOOSE FROM #VALUES for numbers does NOT work correctly with walkmenu
2. CHOOSE FROM filename for numbers works IF you leave out the ORDER BY.
I'm on my way out. Can you submit this to RBTI on behalf of both of us?
David
----- Original Message -----
From: "MikeB" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
Sent: Tuesday, September 16, 2003 12:16 PM
Subject: [RBASE-L] - Re: Walkmenu on currency values
> 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]
> > > > > > > > > > ----------------------------------
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
