[AccessD] SQL INSERT Question

One more thing - the field RS(10) is of type nvarchar and can be up to 4000
characters in length.

Rocky
 




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Wednesday, January 23, 2008 11:08 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] SQL INSERT Question

I have a client who write a lot of his own stuff.  Right now he's trying to
insert into an Access table memo field using the following:
 
 DoCmd.RunSQL "INSERT INTO tEvictionCasesTemp1 ( UDCaseID, Note ) " & _
                 "SELECT " & RS(0) & ", '" & RS(10) & "'"
 
which generates the error: "Syntax error in INSERT INTO statement"
 
RA(n) are the fields in a recordset hooked to SQL database.  The fields
RS(0) and RS(10) contain god data (he checked) with no embedded quotes or
apostrophes. Although he says that he needs to be able to 


The target field Note is a memo field in the Access table. RS(0) has already
been successfully inserted into tEvictionCasesTemp1.
 
What might be causing the syntax error?
 
MTIA
 
Rocky
 

 	
	
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.516 / Virus Database: 269.19.8/1236 - Release Date: 1/21/2008
8:23 PM