Mike
We must be getting different results.
Walkmenu DEFINITELY works just fine with letters, DEFINITELY does NOT work
OK on my PC with numbers. The program you sent me it DOES not work
correctly if you add ORDER BY to the SELECT in the code. And going direct
to the table with #VALUES and numbers it does NOT work correclty.
What are saying - that NO WHERE in windows do listboxes allow you to walk
down a list of numbers:
ie
11
12
13
135
34
52
Press 1, you're on the first
press 3, you're on the 3rd
press 5, you're on the 4th record
Or that you CAN in other windows programs and it DOES work for you in
R:Base?
On my PC, with walkmenu on, #VALUES CHOOSE,
1 I'm on the first
3 I'm on the fifth
5 I'm on the 6th
Same if I use your program to generate the menu and add ORDER BY
David Blocker
----- Original Message -----
From: "MikeB" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
Sent: Tuesday, September 16, 2003 1:43 PM
Subject: [RBASE-L] - Re: Walkmenu on currency values
> Actually both of the problems DO NOT exist in 7.0.
>
> Because of the native behavior of a Windows Listbox, WalkMenu is the
default behavior so it works
> properly.
>
> Check it out. Set Walk Off and the menu will still walk.
>
> I have to believe a submittal for a fix of this type in 6.5 would fall on
deaf ears since there is a
> workaround of sorts.
>
>
> ----- Original Message -----
> From: "David M. Blocker" <[EMAIL PROTECTED]>
> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
> Sent: Tuesday, September 16, 2003 11:46 AM
> Subject: [RBASE-L] - Re: Walkmenu on currency values
>
>
> > 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]
> > > > > > > > > > > > ----------------------------------
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
