I'd be more than happy to but I do not have access to those hallowed halls
where the wonder workers reside.
I'd report it to the v6.5 bug system but you know why that's no going to
help.
Regards,
Alastair.
----- Original Message -----
From: "David M. Blocker" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, September 17, 2003 4:48 PM
Subject: [RBASE-L] - Re: Walkmenu on currency values
> 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]
> > > > > > > > > > > > > > > > ----------------------------------
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > >
> > > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > > >
> > >
> >
> >
>
