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.
_______________________________________________
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.
