|
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 support@foxweb.com 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. 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. |