[AccessD] FW: CodeL

Dear List:
 
Client (see below) is connecting to a SQL back end with ADO (he's doing his
own programming and calling me occasionally for help).  
 
When trying to update a memo field with embedded apostrophes he get a syntax
error.  He says that when he connected with ODBC he didn't have the problem.
 
The code below errors on the Conn.Execute with "incorrect syntax". 
 
I told him to change the apostrophe delimiters around vMemo to double quote
marks.  Then he gets an error which says 'can't be longer than 128
characters.  Memo field is defined as nvarChar 4000.  

I'm pretty weak in SQL and ADO.  Is there a solution to this?
 
MTIA
 
Rocky
 


 
'ADO connection to MS Sql:
 
vMemo is a declared Variant that is loaded with the memo filed and then when
dirty, I am attempting to update the SQL back end.  CLID is the integer ID
number of the current client
 
    Conn.Execute "UPDATE tClients " & _
        "Set [Memo] = '" & vMemo & "' " & _
              "WHERE ClientIndex=" & CLID & ""

 
 
James W. M. Charlton
Charlton Weeks LLP
Attorneys at Law
(661) 265-0969
(800) 388-9878
 


No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.21.6/1316 - Release Date: 3/6/2008
6:58 PM