Michael,
And on no account name any fields "Desc" or any other MySQL reserved words.
Also look at Enum("Y","N") as a substitute for VFP Logical fields or use a
Bit field as a replacement.I have a MySQLClass which has a VFP /TableCursor upload method amongst others that I'll post onto Ed's site later today or first thing tomorrow complete with source code. It takes care of the data conversions for most VFP field types automatically and creates/uploads the data for you. That should get you going in the correct direction. As an aside, I'm going through the same "parallel VFP/MySQL" process with our installed system at the moment - hence the need for the class. Dave Crozier The secret to staying young is to live honestly, eat slowly, and to lie about your age -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Davies Sent: 07 August 2006 09:05 To: [email protected] Subject: Re: migration efforts from FREE DBFs to RDBMS (like SQL Server) If the Nulls don't getcha the Varchars will <g> - and beware the ides of March (or any other date) Andrew Davies MBCS CITP - AndyD 8-)# ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. Please contact [EMAIL PROTECTED] with any queries. ********************************************************************** [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.
