>We are using ASP pages to update Visual Fox 5 tables. We are using textareas from our form to update memo fields. We cannot include carriage returns in our textareas, the odbc chokes and generates error:
>
>Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
>
>[Microsoft][ODBC Visual FoxPro Driver]Command contains unrecognized phrase/keyword.
>
>The only way we can overcome this is to use event handlling to remove the carriage returns. Is this the only way available?
Hi Gary,
What version ODBC driver and ADO version are you using. I use to have this problem and basicly handled it as you are. I'm assuming that you are using ADO recordsets. After upgrading to ADO 2.0 and using the latest VFP ODBC driver the problems were resolved. Updating memo fields with carriage returns and passing data lengths exceeding 255 characters now works :). Also the numeric resolution problem where the numeric field width had to be one more than the maximum width of the value to store is fixed.
Michael McLain