Thanks, Mike, but talk about hammers to crack nuts!!
Regards,
Alastair.
----- Original Message -----
From: "MikeB" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, September 17, 2003 12:45 AM
Subject: [RBASE-L] - Re: Walkmenu on currency values
>
> I Know from experience, this is the default behavior in VB which uses
Windows Native Listbox with a
> wrapper around it with fewer properties and methods exposed and I just
tested a ListBox in Delphi to
> confirm this and that is Its' default behavior or, as it only behaves this
way, maybe I should call
> it the Only behavior.
>
> This is why the Set Walk Off has no effect in 7.0. Even with Walk ON
only, you still can press a
> key and it will take you to the first element in that key range.
>
> But there is no grousing over this issue in 7.0 cause that's just the way
it is and always has been
> in 32bit windows.
>
> Anyways the (Ctxt(Float(currency))) deal should get rid of the Currency
symbol and let it walk for
> you.
>
>
> ----- Original Message -----
> From: "Alastair Burr" <[EMAIL PROTECTED]>
> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
> Sent: Tuesday, September 16, 2003 5:22 PM
> Subject: [RBASE-L] - Re: Walkmenu on currency values
>
>
> > Are you saying that walkmenu works when set to off in v7? Seems odd to
say
> > the least.
> >
> > Fixing v6.5 is pointless at this stage - workaround or not.
> >
> > I thought I asked a simple question but I almost wish I hadn't bothered.
> >
> > Regards,
> > Alastair.
> >
> >
> >
> >
> >
> > ----- Original Message -----
> > From: "MikeB" <[EMAIL PROTECTED]>
> > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
> > Sent: Tuesday, September 16, 2003 6: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]
> > > > > > > > > > > > > > ----------------------------------
> > > > > > > > > > > > > >
> > > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> >
> >
>
