Alastair
Please - can you write the dream team to request - I'm a bit swamped here!
David
----- Original Message -----
From: "Alastair Burr" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, September 17, 2003 1:45 AM
Subject: [RBASE-L] - Re: Walkmenu on currency values
> Thanks, David, I can't believe that such a simple problem caused me so
much
> effort. Perhaps you could ask that the R:Syntax entry for v7 clarifies
what
> works and how?
>
> Regards,
> Alastair.
>
>
> ----- Original Message -----
> From: "David M. Blocker" <[EMAIL PROTECTED]>
> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
> Sent: Wednesday, September 17, 2003 2:22 AM
> Subject: [RBASE-L] - Re: Walkmenu on currency values
>
>
> > No Alastair - it works with Walkmenu ON fine with text, not with spaces,
> not
> > with numbers. But the numbers are inconsistent.
> >
> > David
> >
> > ----- Original Message -----
> > From: "Alastair Burr" <[EMAIL PROTECTED]>
> > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
> > Sent: Tuesday, September 16, 2003 6: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]
> > > > > > > > > > > > > > > ----------------------------------
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > >
> > > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > >
> > >
> >
>
>
