I need to update a memo field using ADO from as ASP application. I've looked at KB Q208208. It only shows how to add a new record and populate the memo using the "adchunk" approach. I need to know how use this to update a memo in an existing record. I have a free table with a CDX file that has 3 indices. I need to know how to fetch a single record's memo using a unique key value (like using "set order to" then doing a seek in VFP), and then write back an updated version of them memo, all with ADO. I know the syntax for creating a connection, etc, but I don't know the rules/techniques for performing these simple steps. Can somebody help me? Thanks very much!

Here's what I'm getting: Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Visual FoxPro Driver]Cannot update the cursor.

Here's the code snippet, given the memo field "comments"

* This is already done successfully:
Select Comments  From MyDBF Where ID=SomeUniqueKeyVal
* ID is a field that is indexed alone in a rushmore-optimized index
* Assume the connection is named "conn" and the recordset is named "rs"
* Set up the test:
cLongParm=rs("comments") + chr(13) + string(254,"A") 
liChunkSize = 254
Rs.Fields("comments")=""
FOR i = 1 to len(lcLongParm) step liChunkSize
  liStartAt = i
  liWorkString = mid(lcLongParm, liStartAt, liChunkSize)
  Rs.Fields("comments").AppendChunk(liWorkString)
NEXT
conn.execute "Set Reprocess to 5 seconds",,1
* This fails:
Rs.Update