Ted, you're a lovely man, thank you thank you.
-----Original Message-----
From: profoxtech-bounces /at/ leafe D.OT com [mailto:profoxtech-bounces@leafe.com] On
Behalf Of Ted Roche
Sent: 31 May 2004 14:57
To: profoxtech /at/ leafe D.OT com
Subject: RE: ReQuery Remote Views
Chris Davis wrote:
> Another MySQL question. I am requerying my remove views after
> changed the
> local parameter and I get "View definition has been changed"
>
Chris:
This is one of those cases where supplying more information might help to
answer your question.
My guess is that your connection is telling VFP that the size of the
character fields are not the same as they were before. This is caused by the
default behavior of the MyODBC driver (mine, anyway, version 2.50.39, dated
2001-09-18). In the ODBC manager, you need to check the checkboxes for
"Don't optimize column width" and "Pad CHAR to full length."
Both Bob Lee (Mar 2002) and Dan Jurden (Feb, Mar, Apr 2004) had excellent
articles in FoxTalk on using MySQL with many other recommendations for best
practices.
If that doesn't solve your problem, you should be able to supply us with
more information (versions, platforms, OS's, code for connection and view)
to narrow down the problem.
[excessive quoting removed by server]
©2004 Chris Davis |
