that str(int) = len() of 10; that's my point: default is 10 regardless of
the underlying type.
----- Original Message -----
From: "Stephen the Cook" <[EMAIL PROTECTED]>
To: "'ProFox Email List'" <[email protected]>
Sent: Saturday, July 15, 2006 4:06 PM
Subject: RE: Alltrim(str(<numeric>)) works, but why?
Lew <> wrote:
I feel that Vince is right with the additional suspicion that since
str() was once the workhorse of ryo reporting (before reportwriters),
fox sees it, at least partially, as a memvar & not just a function.
My idea being that alltim'ing a string that's 10 chars long doesn't
do anything. FoxBase paired it with numeric types (also default width
10) which also have a kind of mixed lineage: width & decimals values
are more related to appearance than internal storage.
I think that your confusing technology here, in that str(int) = len() of
10.
Alltrim() is a function, but the SQL engine disguards it because it's to
costly to use. You want speed, or do you want it pretty?
Stephen Russell
DBA / Operations Developer
Memphis TN 38115
901.246-0159
http://spaces.msn.com/members/srussell/
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.1/389 - Release Date: 7/14/2006
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
