Hi Andrew,
I think Chrisof meant
> ? ROUND(1.920001-0.005,2)
> ? ROUND(1.92-0.005,2)
>
Yep, thanks!
Christof
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
___
Post
On 1/25/2012 11:42 PM, MB Software Solutions, LLC wrote:
> I'm dealing with very large datasets (millions of rows) and so my SQL
> needs to be "on" more than ever! I'm using MySQL and I'm using EXPLAIN
> to help me make sure my SQL is optimized. I've got several
> fields, two of which are in my
On 1/25/2012 5:21 PM, Malcolm Greene wrote:
> Stumbled across the following Zed Shaw site on python-list.
>
> Typical Zed Shaw humor (I admit I find him funny) and an
> excellent set of links to documentation on a variety of
> languages/products.
> [1]http://programming-motherf_cker.com/buy.html
>
This is what we just bought
http://www.newegg.com/Product/Product.aspx?Item=N82E16822122015&Tpk=NETGEAR%20ReadyNAS%20NV%2b%204-Bay%204TB%20%284%20x%201000GB%29
From: Tracy Pearson
To: profox@leafe.com
Sent: Wednesday, January 25, 2012 4:50 PM
Subject: VFP and
I think Chrisof meant
? ROUND(1.920001-0.005,2)
? ROUND(1.92-0.005,2)
I use
? INT(1.92*100)/100
? INT(1.920001*100)/100
Kind regards
Andrew Stirling
01250 874580
supp...@calcpay.co.uk
http://www.calcpay.co.uk
HMRC Accredited UK payroll program
On 25/01/2012 21:29, Christo
On Jan 25, 2012, at 4:21 PM, Malcolm Greene wrote:
> Replace the underscore in the above URL with "u" for a working
> link.
Do you speak it??
-- Ed Leafe
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mai
>
> What is the best way systems round Down ?
>
ROUND(nValue-0.5, 0)
INT() and FLOOR() both have issues with numbers very close to the boundary
due to the lack of precision with floating point numbers.
When you say rounding down you might need to check how to handle negative
values. Some custome
That's not really rounding down, that's truncating.
From: Tracy Pearson
To: profox@leafe.com
Sent: Wednesday, January 25, 2012 4:01 PM
Subject: RE: Rounding DOWN
Sytze de Boer wrote on 2012-01-25:
> Hi Folk
>
> What is the best way systems round Down
Sytze de Boer wrote on 2012-01-25:
> Hi Folk
>
> What is the best way systems round Down ?
> e.g.
> 1.9256 to 1.92
> 5.565 to 5.56
> 4.449 to 4.44
Sytze,
The FLOOR() function. Or just INT() if your numbers are always greater than
0.
Tracy Pearson
PowerChurch Software
_
Did you look at that link, Michael? In Office 2010, 1024 characters will
display in the cell itself but 32K will display in the formula bar. I'm sure
there are similar numbers in earlier versions of Office.
As to why you would want to store and manipulate 32K of text data in a cell in
Excel, I
I'm confused, however.
You can display 1024 but can store much much more. But what is the point of
storing it if you can't display it?
From: Richard Kaye
To: "profox@leafe.com"
Sent: Wednesday, January 25, 2012 2:39 PM
Subject: RE: Foxpro and Excel quest
I don't usually print this kind of stuff from Excel so I'd have to try it out.
The point I was trying to make is that you can store significantly more than
255 characters in a cell in Excel.
--
rk
-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com
There's a display limit, but can you print it?
From: Richard Kaye
To: "profox@leafe.com"
Sent: Wednesday, January 25, 2012 2:12 PM
Subject: RE: Foxpro and Excel question
Hmm... Not exactly. Don't confuse display with capacity. See the link below.
(And it
On 1/25/2012 12:56 PM, Stephen Russell wrote:
> On Wed, Jan 25, 2012 at 11:43 AM, MB Software Solutions, LLC
> wrote:
>> MySQL 5 (actually MariaDB but same thing for this purpose)
>>
>> I want to know the value of rows affected by an UPDATE operation.
>> What's the _TALLY equivalent in MySQL?
> -
Hmm... Not exactly. Don't confuse display with capacity. See the link below.
(And it is different depending on what version of Excel you are using.)
I dump large memo files into Excel cells on a regular basis. Finally, you do
need to do this via automation as opposed to using xBase commands if y
I think it may be up to 1024 now, but you're right. We wound up scrapping this
because our memo fields are bigger than that. i wound up just creating an
Excel sheet with a line for each memo line.
From: Richard A. Mertl
To: profox@leafe.com; profoxt...@lea
thanks, yes, very well.
Been retired 5 years now (where does time go?) - so decided to stir up
the little grey cells by having a 3rd (and final) attempt at Python** so
I've been following profox to help get my programming head on again.
cheers - AndyD 8-)₹
P.S. ** tried a book called "Programmi
Keep in mind that the character limit in Excel is 255. You might end up
loosing data.
Richard A. Mertl, C.A.
T 514 885 4257
F 514 481 6196
E rame...@richardamertl.ca
W www.richardamertl.ca
Member of L'Ordre des comptable agrees du Quebec
Member of The Ontario Institute of Chartered Accountants
Me
I had a vendor send a email and cc me
"Please send Mike Madman a copy of the files".
So I blasted him "That's Madigan NOT Madman".
He claimed it was his autocorrect, but I'm not convinced. LOL
From: Stephen Russell
To: ProFox Email List
Sent: Wednesday, Ja
On Wed, Jan 25, 2012 at 11:43 AM, MB Software Solutions, LLC
wrote:
> MySQL 5 (actually MariaDB but same thing for this purpose)
>
> I want to know the value of rows affected by an UPDATE operation.
> What's the _TALLY equivalent in MySQL?
This is pretty clear on what to use when.
h
MySQL 5 (actually MariaDB but same thing for this purpose)
I want to know the value of rows affected by an UPDATE operation.
What's the _TALLY equivalent in MySQL?
Thanks,
--Mike
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
21 matches
Mail list logo
