> > The ODBC or fox converted my varchar to a char.  That is the problem.

> I'm sorry--I must have missed something.  What's wrong with it being a
> CHAR type on the Fox side?

Maybe he doesn't want to incessantly deal with stupid trailing spaces
in everything? I don't blame him, but it's an inherent
VFP-ism(Dbase-ism)...

Bruce, I don't believe VFP's ODBC code supports the varchar -> varchar
conversion, as it's older code that existed before the varchar type
existed in VFP(added in VFP8 or VFP9, I believe). I think you're stuck
with a char() field on the VFP side and you'll be stuck with lots of
ALLTRIM()'s, etc. as all my VFP code is forced to use...


-- 
Derek


_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** 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.

Reply via email to