trim() is ignored in the first example & respected in the second. I still
don't understand the difference.
----- Original Message -----
From: "Vince Teachout" <[EMAIL PROTECTED]>
To: "ProFox Email List" <[email protected]>
Sent: Friday, July 14, 2006 10:38 PM
Subject: Re: Alltrim(str(<numeric>)) works, but why? - SOLVED
Ok, I've solved it.
After taking a break, and coming back and spotting this thread again, I
realized that my answer could be boiled down to "I think Alltrim() is
ignored by SQL". To test, I added a 25 char field, filled it with various
lengths of data (none > 12 chars), and ran 'Select Alltrim(foobar) from
Mycrap'. Sure enough, the field length is 25.
Armed with that, I googled "alltrim ignored by sql" and got tons o' hits
that verified this. Probably the most succinct was this one from "What's
new in VFP9", from....Hentzenwerke. Bad, naughty, senile Whil, for not
chiming right on in with the answer!
http://foxcentral.net/microsoft/WhatsNewInVFP9_Chapter09.htm
Look for this: Specifying the data type of variable length values
Very interesting, showing this and a related problem, and the solutions in
vfp9.
[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.
