Hi,
Any idea to change the point by comma in the decimal numbers? I convert each
query and each insert or update... exist other way?
Salut,
Josep
--
View this message in context:
http://www.nabble.com/NumberFormat-with-SQLite-or-mySQL-tp24232124p24232124.html
Sent from the Revolution - User
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
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
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
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?
Salut,
Josep
--
View this message in context:
http:/
Hey thanks. That will be a big help.
___
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
e format number like accountants
>
> $ 000,000,000.00 ?
>
> I noticed it has the option for #.00 to set two decimal places but no add
> the commas or put a dollar sign. I remember that in hypercard we had an
> external for this.
>
> Thanks,
>
> Bill
>
No - I don't think so.
2008/8/27 william humphrey <[EMAIL PROTECTED]>
> Can the format command be used to solve the common task of needing a number
> 000,000,000 (put the commas in)?
>
> Or the format number like accountants
>
> $ 000,000,000.00 ?
>
> I noticed it has the option for #
Can the format command be used to solve the common task of needing a number
000,000,000 (put the commas in)?
Or the format number like accountants
$ 000,000,000.00 ?
I noticed it has the option for #.00 to set two decimal places but no add
the commas or put a dollar sign. I remember
else
> >-- Local specific code
> >if extended is true then
> >-- 1981-04-05T14:30:30-05:00
> >put "%4d-%02d-%02dT%02d:%02d:%02d %04s" into baseString
> >else
> >--
else
>-- 19810405T14:30:30-05 00
> put "%4d%02d%02dT%02d:%02d:%02d%04s" into baseString
>end if
>
>put format(baseString, y, mons, d, h, mins, s, utcOffset) into
> fDate
>return fDate
>en
baseString, y, mons, d, h, mins, s, utcOffset) into fDate
return fDate
end if
end if
end date_Construct8601
- instead of using your padding function and numberFormat, I just used
format to supply the leading zeroes as required.
- your UTC calculation was going the wrong way. I am
mbers 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 alwa
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 fi
of someDate) into d
convert someDate to internet date
if extended is true then
-- 1981-04-05
put "%4s-%2s-%2s" into baseString
else
-- 19810405
put "%4s%2s%2s" into baseString
end if
set
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
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'
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.##"
>>>
>>>>
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 u
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.##"
>>
>>&g
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 w
> 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
&g
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
--
B
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 dat
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
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 &qu
On Nov 2, 2006, at 4:17 PM, David Bovill wrote:
Does 'put it into msg' work?
No - same. But I need the 12 digit value passed to AppleScript -
the message
box was just an example. So it looks like I can do this with "& empty"
tagged on just before I need the result. Thanks for the help.
On 02/11/06, Dar Scott <[EMAIL PROTECTED]> wrote:
Does 'put it into msg' work?
No - same. But I need the 12 digit value passed to AppleScript - the message
box was just an example. So it looks like I can do this with "& empty"
tagged on just before I need the result. Thanks for the help.
___
On Nov 2, 2006, at 3:17 PM, David Bovill wrote:
put it & empty
I think this is a bug - no?
Yes.
But this might be understandable.
It looks as though 'put it' will not (always) apply numberFormat and
'it & empty' will. (BTW, the latter is a common wa
Hi Dar!
On 01/11/06, Dar Scott <[EMAIL PROTECTED]> wrote:
By the way, the numberFormat setting is not needed for a level of
arithmetic accuracy. The result of arithmetic is always about 15
digits. The numberFormat comes into play the first time the result
of arithmetic is used a
On Nov 1, 2006, at 8:57 PM, David Bovill wrote:
Well I am stuck. I have not idea why it does not work. I cannot
pass these
12 place decimals as parameters and why the script below does not
work beats
me :(
By the way, the numberFormat setting is not needed for a level of
arithmetic
On Nov 1, 2006, at 8:57 PM, David Bovill wrote:
Well I am stuck. I have not idea why it does not work. I cannot
pass these
12 place decimals as parameters and why the script below does not
work beats
me :(
This works fine for me. I'm on PPC OS X 10.4.7 using Rev 2.7.4.
I hope that is a
Hi David,
I was able to replicate your result, but it seems to be related to
putting the value into the message box. If I do this:
set the numberformat to "#."
put 0.006911491563 into projectedWidth
put -1. * projectedWidth into field 1
Then "fi
doing maths on them I nedd to set the number format first to deal with this
level of accuracy - fine, except I can"t figure it - sometimes it is working
and sometimes not :(
Here is my test script:
on mouseDoubleUp
set the numberformat to "#."
put 0.006911491563 i
eUp
set the numberformat to "#."
put 0.006911491563 into projectedWidth
put -1. * projectedWidth
end mouseDoubleUp
When I pasted this on a new stacks card script and doule click I get:
-0.006911
When I paste the 3 lines of the handler into the message box
Thanks Chipp
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-
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&q
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 = '
Thank's * 2
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-
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
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 =
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 s
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 '&&
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
Hello,
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?
Thanks,
Gray in Greensboro
> >
> > Hi
> >
> > You've had quite a number of solutions but here's
> > another one:
> >
> > -- function to return the the time format (h:mm:ss)
> > from an input in seconds
> > function timeFormat timeInSecs
> > if timeInSecs = 0 then
> > put "0:00:00" into timeInForm
> > else
> > pu
--- Monte Goulding <[EMAIL PROTECTED]>
wrote:
>
> Hi
>
> You've had quite a number of solutions but here's
> another one:
>
> -- function to return the the time format (h:mm:ss)
> from an input in seconds
> function timeFormat timeInSecs
> if timeInSecs = 0 then
> put "0:00:00" into timeIn
On 8/22/03 12:45 PM, [EMAIL PROTECTED] wrote:
This will give you results like "10:53:12 PM" -- that is, you'll get the
hour, minute, second *and* whether it's AM or PM. Of course, your original
question didn't mention the AM/PM bit at all; since the "long time" time format
automatically incl
Cubist,
Thanks for the tutorial on date/time conversion!
You should send this to the tips section of Runrev.
In fact, the PM was displaying in my scenario I posted a few minutes
ago, but my field was too small to show it. My use is for short timed
practice tests, so it's not appropriate to
initial hour
and colon, leaves minutes and seconds
put gtheSecsLong into field "Time"
send "updateTimer" to me in 1 second
end upDateTimer
Mark
On Friday, August 22, 2003, at 09:11 AM, J. Landman Gay wrote:
Is there a numberformat or other option that will display sec
sez [EMAIL PROTECTED]:
>Is there a numberformat or other option that will display seconds in
>standard 00:00:00 format?
The CONVERT function is your friend for all things related to display of
time and/or dates. To a first approximation:
function Sec2Standard DaSecs
convert DaSec
TECTED]
> Subject: seconds to standard time numberformat?
>
> Is there a numberformat or other option that will display seconds in
> standard 00:00:00 format?
>
> I've got a "send to me in 1 second...add 1 to field theTime" scenario
> going on a project, and would like
On 8/22/03 9:35 AM, Mark Swindell wrote:
Is there a numberformat or other option that will display seconds in
standard 00:00:00 format?
get the seconds
convert it to long time
put it
--
Jacqueline Landman Gay | [EMAIL PROTECTED]
HyperActive Software | http
Is there a numberformat or other option that will display seconds in
standard 00:00:00 format?
I've got a "send to me in 1 second...add 1 to field theTime" scenario
going on a project, and would like the result to display in standard
form, rather than raw seconds. What'
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
>
>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 ea
Steve Messimer and Sivakatirswami both had
questions/remarks regarding the numberFormat.
It wasn't always behaving properly for me either,
which is why I switched to using the 'format' command.
It's quite flexible indeed, though its C-inherited
syntax is a bit awkward at fi
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.5
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
&g
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 cu
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
61 matches
Mail list logo