Hi, I need to update a cache field that contains some user comments. The VB6 application retrieves data from cache, allows the user to amend it and then saves it back. The method is basically an ADODB command containing an update statement. The problem occurs if a user puts in an apostrophe or single quote mark in the comments! Then it falls over because cache thinks the next bit is a field name.
Any suggestions gratefully received. Thanks Steve W
