Date:  01/07/2002 11:06:31 AM Msg ID:  000283
From:  Brian Moran Thread:  000283
Subject:  Memo Field maxlength???
With the regards to FoxPro memo field...is there any reason why I should not be allowed to insert more than 225 characters with an Insert statement.

I can insert as many characters when I type directly into the field using the db interface, but when I use an insert statement, it errors out at 225.

ERROR:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Visual FoxPro Driver]Command contains unrecognized phrase/keyword.

I figured it had to be a driver problem but I just spent a few hours making sure everything is up to date.  They are still using 6.0 so I dont know if this is something that was fixed in 7.0.