Re: numberFormat to datagrid
Hi Josep, Hi Klaus, I have it in the FillData but nothing happen, all the values are showed with 6 decimal places.. hmmm, did work here, at least in an example button, not tested with a datagrid however. Could you please post the complete handler? Just to be sure. Salut, Josep Best Klaus -- Klaus Major http://www.major-k.de kl...@major.on-rev.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: numberFormat to datagrid
Hi Klaus, I have it in the FillData but nothing happen, all the values are showed with 6 decimal places.. Salut, Josep -- View this message in context: http://www.nabble.com/numberFormat-to-datagrid-tp24152520p24156822.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: numberFormat to datagrid
Hi Josep, Hi list, How to apply the "set the numberFormat to "#.000" into the datagrid ? I have the numeric values with 6 positions for decimals but only I want show 3. I put it into the FillData but nothing happen.. Any idea? Yep :-) "the numberformat" will only affect the result of a calculation. So you could do this in your "fillData" handler: ... set the numberFormat to "#.000 add 0 to your_value_here ... That should do the job. Salut, Josep Best Klaus -- Klaus Major http://www.major-k.de kl...@major.on-rev.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Numberformat
Great! 2008/8/26 Mark Smith <[EMAIL PROTECTED]> > David, you need "%02d". > > Best, > > Mark > > > On 26 Aug 2008, at 21:20, David Bovill wrote: > > 2008/8/26 Mark Smith <[EMAIL PROTECTED]> >> >> The docs say "It affects numbers only when they are calculated and then >>> displayed or used as strings." >>> >>> I found that if you use >> padedNum> >>> >>> this forces padedNum to be a string, and you get '08' >>> >>> I've always found the numberFormat thing confusing, so I always use >>> 'format' in these cases... >>> >> >> >> Hi mark - I'm moving over a date function to use "format" - but in the >> docs I could not figure how to make it add trailing zeros? "%2d" did not >> seem to work: >> >>if extended is true then >>-- 1981-04-05T14:30:30-05:00 >>put "%4s-%2s-%2sT%2s:%2s:%2s-%4s" into baseString >>else >>-- 19810405T14:30:30-05 00 >>put "%4s%2s%2sT%2s:%2s:%2s %4s" into baseString >>end if >> >>put format(baseString, y, mons, d, h, mins, s, z) into fDate >> >> What should I usee? >> ___ >> use-revolution mailing list >> use-revolution@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your >> subscription preferences: >> http://lists.runrev.com/mailman/listinfo/use-revolution >> > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Numberformat
David, you need "%02d". Best, Mark On 26 Aug 2008, at 21:20, David Bovill wrote: 2008/8/26 Mark Smith <[EMAIL PROTECTED]> The docs say "It affects numbers only when they are calculated and then displayed or used as strings." I found that if you use padedNum> this forces padedNum to be a string, and you get '08' I've always found the numberFormat thing confusing, so I always use 'format' in these cases... Hi mark - I'm moving over a date function to use "format" - but in the docs I could not figure how to make it add trailing zeros? "%2d" did not seem to work: if extended is true then -- 1981-04-05T14:30:30-05:00 put "%4s-%2s-%2sT%2s:%2s:%2s-%4s" into baseString else -- 19810405T14:30:30-05 00 put "%4s%2s%2sT%2s:%2s:%2s %4s" into baseString end if put format(baseString, y, mons, d, h, mins, s, z) into fDate What should I usee? ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Numberformat
Hi William - the functions I'm posting are examples of a much more complicated function I am trying to update / simplify. Its real ugly uless I can use the nice built in "format" functions :) 2008/8/26 william humphrey <[EMAIL PROTECTED]> > Spoke to soon > try > > put "0" & "8" + 2 > > > and this works with the padded zero like you want. Much simpler than hard > to > understand add zero thing. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Numberformat
2008/8/26 Mark Smith <[EMAIL PROTECTED]> > The docs say "It affects numbers only when they are calculated and then > displayed or used as strings." > > I found that if you use > > this forces padedNum to be a string, and you get '08' > > I've always found the numberFormat thing confusing, so I always use > 'format' in these cases... Hi mark - I'm moving over a date function to use "format" - but in the docs I could not figure how to make it add trailing zeros? "%2d" did not seem to work: if extended is true then -- 1981-04-05T14:30:30-05:00 put "%4s-%2s-%2sT%2s:%2s:%2s-%4s" into baseString else -- 19810405T14:30:30-05 00 put "%4s%2s%2sT%2s:%2s:%2s %4s" into baseString end if put format(baseString, y, mons, d, h, mins, s, z) into fDate What should I usee? ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Numberformat
Spoke to soon try put "0" & "8" + 2 and this works with the padded zero like you want. Much simpler than hard to understand add zero thing. On Tue, Aug 26, 2008 at 3:55 PM, william humphrey <[EMAIL PROTECTED]>wrote: > And if you do what I say it stops being a number and becomes a text string? > > > On Tue, Aug 26, 2008 at 3:54 PM, Colin Holgate <[EMAIL PROTECTED]> wrote: > >> At 8:46 PM +0100 8/26/08, David Bovill wrote: >> >>> > set the numberformat to "00.##" >>> put item 1 of someNum + 0 into padedNum >>> > set the numberformat to "0.##" >>> >> >> I think the problem is that the numberformat only affects how the number >> appears, not what it is. Because you set it back to "0.##", what would >> have been 08 becomes 8. padeNum contains the value of 8, not the string of >> "08". >> >> >> >> >> ___ >> use-revolution mailing list >> use-revolution@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your >> subscription preferences: >> http://lists.runrev.com/mailman/listinfo/use-revolution >> > > > > -- > http://www.bluewatermaritime.com > -- http://www.bluewatermaritime.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Numberformat
The docs say "It affects numbers only when they are calculated and
then displayed or used as strings."
I found that if you use padedNum>
this forces padedNum to be a string, and you get '08'
I've always found the numberFormat thing confusing, so I always use
'format' in these cases...
Best,
Mark
On 26 Aug 2008, at 20:46, David Bovill wrote:
I get a "8".
Here I've extracted this function:
function date_PadTwoZeros someNum
set the numberformat to "00.##"
put item 1 of someNum + 0 into padedNum
set the numberformat to "0.##"
return padedNum
end date_PadTwoZeros
put date_PadTwoZeros("8") --> "8"
function date_PadTwoZeros someNum
if the number of chars of someNum = 1 then
return "0" & someNum
else
return someNum
end if
end date_PadTwoZeros
put date_PadTwoZeros("8") --> "08"
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Numberformat
And if you do what I say it stops being a number and becomes a text string? On Tue, Aug 26, 2008 at 3:54 PM, Colin Holgate <[EMAIL PROTECTED]> wrote: > At 8:46 PM +0100 8/26/08, David Bovill wrote: > >> > set the numberformat to "00.##" >> >>> put item 1 of someNum + 0 into padedNum >>> >> > set the numberformat to "0.##" >> > > I think the problem is that the numberformat only affects how the number > appears, not what it is. Because you set it back to "0.##", what would > have been 08 becomes 8. padeNum contains the value of 8, not the string of > "08". > > > > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > -- http://www.bluewatermaritime.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Numberformat
At 8:46 PM +0100 8/26/08, David Bovill wrote: > set the numberformat to "00.##" put item 1 of someNum + 0 into padedNum > set the numberformat to "0.##" I think the problem is that the numberformat only affects how the number appears, not what it is. Because you set it back to "0.##", what would have been 08 becomes 8. padeNum contains the value of 8, not the string of "08". ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Numberformat
I don't get it. Why not just say put "0" & "1" into text-string-with-zero-in-the-front. Why would adding a zero do that? On Tue, Aug 26, 2008 at 3:48 PM, Mark Schonewille < [EMAIL PROTECTED]> wrote: > Hi David, > > I tried the following script: > > on mouseUp > beep > put 1,8 into someDate > set the numberformat to "00.##" > put item 1 of someDate + 0 into y > put item 2 of someDate + 0 into someMonth > put y & cr & someMonth > end mouseUp > > which gives me > > 01 > 08 > > -- > Best regards, > > Mark Schonewille > > Economy-x-Talk Consulting and Software Engineering > http://economy-x-talk.com > http://www.salery.biz > http://facebook.economy-x-talk.com > > Benefit from our inexpensive hosting services. See > http://economy-x-talk.com/server.html for more info. > > > On 26 aug 2008, at 21:31, David Bovill wrote: > > I can never get this working... or has something changed? I want a number >> formatted to 2 chars and padded with leading zeros if it is only 1 digit. >> I >> thought numberformat did this (for containers as well as fields by forcing >> a >> calculation by adding zero. So: >> >> set the numberformat to "00.##" >> put item 1 of someDate + 0 into y >> put item 2 of someDate + 0 into someMonth >> >> Well its not working now. I get "8" instead of "08" for this month? >> > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > -- http://www.bluewatermaritime.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Numberformat
Hi David, I tried the following script: on mouseUp beep put 1,8 into someDate set the numberformat to "00.##" put item 1 of someDate + 0 into y put item 2 of someDate + 0 into someMonth put y & cr & someMonth end mouseUp which gives me 01 08 -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering http://economy-x-talk.com http://www.salery.biz http://facebook.economy-x-talk.com Benefit from our inexpensive hosting services. See http://economy-x-talk.com/server.html for more info. On 26 aug 2008, at 21:31, David Bovill wrote: I can never get this working... or has something changed? I want a number formatted to 2 chars and padded with leading zeros if it is only 1 digit. I thought numberformat did this (for containers as well as fields by forcing a calculation by adding zero. So: set the numberformat to "00.##" put item 1 of someDate + 0 into y put item 2 of someDate + 0 into someMonth Well its not working now. I get "8" instead of "08" for this month? ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Numberformat
I get a "8".
Here I've extracted this function:
function date_PadTwoZeros someNum
> set the numberformat to "00.##"
> put item 1 of someNum + 0 into padedNum
> set the numberformat to "0.##"
> return padedNum
> end date_PadTwoZeros
>
> put date_PadTwoZeros("8") --> "8"
>
> function date_PadTwoZeros someNum
> if the number of chars of someNum = 1 then
> return "0" & someNum
> else
> return someNum
> end if
> end date_PadTwoZeros
>
> put date_PadTwoZeros("8") --> "08"
>
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Numberformat
David Bovill wrote: I can never get this working... or has something changed? I want a number formatted to 2 chars and padded with leading zeros if it is only 1 digit. I thought numberformat did this (for containers as well as fields by forcing a calculation by adding zero. So: set the numberformat to "00.##" put item 1 of someDate + 0 into y put item 2 of someDate + 0 into someMonth Well its not working now. I get "8" instead of "08" for this month? What happens in your script after the last line you posted? -- Richard Gaskin Managing Editor, revJournal ___ Rev tips, tutorials and more: http://www.revJournal.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: numberFormat
Hi Liam, You need to perform a math action on it first. So, do: put it into tShowid add 0 to tShowID should do it. liamlambert wrote: I have this bit of code the numberFormat is not giving me two zeros after the decimal point Why ??? thanks in advance global gConID get fld "showid" put it into tshowid set the numberFormat to "#0.00" put "SELECT sum (child) FROM Booking where showid = '"& tshowid & "'" into tChild put revdb_querylist(,,gConID,tChild) into tcSeats put tCseats into fld "child" put "SELECT sum (adult) FROM Booking where showid = '"& tshowid & "'" into tAdult put revdb_querylist(,,gConID,tAdult) into tAseats put tAseats into fld "Adult" put "SELECT sum (cashDb) FROM Booking where showid = '"& tshowid & "'" into tCash put revdb_querylist(,,gConID,tCash) into tCashFld put tCashFld into fld "cash" Liam Lambert [EMAIL PROTECTED] IRELAND ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- -- Chipp Walters www.altuit.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: NumberFormat
Hi Liam, Specifying the numberFormat is not enough: If you want the numberFormat applied, you *must* make any numeric calculation :-) For instance: put tFinalTotal * 1 into fld "FinalTotal" Le 17 janv. 06 à 17:44, liamlambert a écrit : Hi all I am calling a col total from a data Base and not getting the right format Say the Total is 100.50 I am getting 100.5 this is the code set the numberFormat to "00.00" get fld "showid" put it into tshowid put "SELECT sum (total) FROM showDb where showid = '"& tshowid & "'" into tTotal put revdb_querylist(,,gConID,tTotal) into tFinalTotal put tFinalTotal into fld "FinalTotal" Best Regards from Paris, Eric Chatonet -- http://www.sosmartsoftware.com/[EMAIL PROTECTED]/ ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: NumberFormat in field
Gray Steifel <[EMAIL PROTECTED]> wrote:
> How, if possible, does this work in Revolution?
There is nothing as practical in RR ;-)
Though, you use the "format" function, as below:
In a "budget" stack, I have two sets of flds
the first one to note the expenses by category, one by line
the second set contains sums by category (the name prefixed par a "s")
the summation is provoked by a closefield
(handler placed in the group script)
to use the "sum" function I have to replace the cr by comma
=
on closefield
put the short name of the target into lechamp
replace comma with "." in fld lechamp
-- to replace the comma used here in Europe
put fld lechamp into montants
replace return with comma in montants
put "S" & lechamp into letotal
put format("%3.2f",sum(montants)) into fld letotal
end closefield
--
Vous parlez français ? faites un tour sur le groupe francophone !
[EMAIL PROTECTED]
Jetez un oeil sur RevoBlog !
___
use-revolution mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution
Re: NumberFormat in field
On Saturday, April 10, 2004, at 05:17 PM, Dar Scott wrote: The global numberFormat property comes into play whenever the result of a math operation or math function application is used as a string, as in the case when it is put into a field, used as an array key, or used with the '&' operator. I goofed. Though numberFormat is not associated with an object, it is not global in Revolution; it is local to a handler and even to a particular call of the function or command. Dar Scott ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: NumberFormat in field
On Saturday, April 10, 2004, at 02:40 PM, Gray Steifel wrote: Converted a Hcard accounting program to Rev., where I use extensively the “set numberFormat to 0.00” for all fields with numbers and/or the data sent to the field. How, if possible, does this work in Revolution? The global numberFormat property comes into play whenever the result of a math operation or math function application is used as a string, as in the case when it is put into a field, used as an array key, or used with the '&' operator. Dar Scott ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: numberFormat prop
On Tuesday, July 9, 2002, at 02:58 PM, [EMAIL PROTECTED] wrote: > thats easy, fields do not have a numberFormat property. Ah, but maybe you can make one! And a number property, too, of course, to set and get the number. Add a few more handlers for events to handle input and (tah-dah) a numeric field! Dar Scott ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
RE: numberFormat prop
> >Rob, > >>> Anybody know how to set the decimal precision of a numeric value? I have >>> looked through the docs but I can't seem to find the reference. >> >> Hi Steve, >> >> Did you check the numberFormat property? > thats easy, fields do not have a numberFormat property. It works as follows: set the numberFormat to "0.00" put (numeric expression) into fld "xy" set the numberFormat to "0.000" add 0 to fld "xy" set the numberFormat to "0." put fld "xy"+0 into fld "xy" set the numberFormat to "0.0" put (numeric expression) & "" into variable true, at least it worked this way in Hypercard (see p. 442). Peter ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: numberFormat prop
It is often necessary to do a fake calculation to force the numberFormat to be applied. Try this script: put "123.56789" into theNum set the numberFormat to "#.00" answer theNum -- gives 123.56789 add 0 to theNum answer theNum -- gives 123.57 You can't apply a numberFormat to a field but you can take the number out of the field, format it and put it back again, perhaps in a closeField handler. Cheers, Sarah On Wednesday, July 10, 2002, at 06:42 AM, Steve Messimer wrote: > Rob, > >>> Anybody know how to set the decimal precision of a numeric value? I >>> have >>> looked through the docs but I can't seem to find the reference. >> >> Hi Steve, >> >> Did you check the numberFormat property? > > After thrashing around a bit I did find the numberFormat property on my > own. > For some reason I was unable to get it to work correctly. I think the > issue > had to do with how and to what type of container it can be applied. I > presumed that it can be applied to any container. > > I tried: > > set the numberFormat of fld "myFld" to "00.0" -- (and 00.0 and "##.#") > none > of which worked > > then I tried: > > set the numberFormat of calcHolder to 00.0 -- where calcHolder is a var. > (also tried 00.0 and "##.#") didn't work either > > Finally, I just trunc'd the dang thing and I got pretty much what I was > aiming for. I decided I really didn't need the decimal after all. > > put trunc(calcHolder * 100) into fld "myFld" > > That having been said it would be nice to see an example of how the > numberFormat should work. :-) Any examples will be much appreciated. > > Regards, > > Steve > > Stephen R. Messimer > Messimer Computing, Inc > 208 1st Ave South > Escanaba, MI 49829 > www.messimercomputing.com > > > ___ > use-revolution mailing list > [EMAIL PROTECTED] > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: numberFormat prop
On Tuesday, July 9, 2002, at 02:48 PM, Scott Rossi wrote: > Recently, "Steve Messimer" wrote: > >> it would be nice to see an example of how the >> numberFormat should work. > > I believe the numberFormat is a global property, not applied to > specific > controls. So you simply say "set the numberFormat to 0.00" and > then any > scripts currently executing use this format. It's local. And be sure and read the paragraph marked "important" that explains that this applies only to numbers becoming strings, not to those just sitting there looking like numerals. (Values can be character strings and--in a not-quite transparent way--numbers.) Dar Scott ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: numberFormat prop
Recently, "Steve Messimer" wrote: > it would be nice to see an example of how the > numberFormat should work. I believe the numberFormat is a global property, not applied to specific controls. So you simply say "set the numberFormat to 0.00" and then any scripts currently executing use this format. Regards, Scott Rossi Creative Director Tactile Media, Multimedia & Design - E: [EMAIL PROTECTED] W: http://www.tactilemedia.com ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
