|VFP's memo fields can contain large amounts of data, but the problem here is your use of ODBC. A lot of ODBC drivers limit the size of text or memo fields to 254 characters. Obviously, if you are writing to a FoxPro table from a FoxWeb script you do not have to use ODBC.|
FoxWeb Support Team
Sent by Brian Moran on 01/07/2002 11:06:31 AM:
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.
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.