[AccessD] SQL INSERT Question

LOL, I just thought it was funny.

Drew

-----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 7:25 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] SQL INSERT Question

Don't get cheeky.  I have god data.

Rocky
 




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Wednesday, January 23, 2008 1:59 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] SQL INSERT Question

Isn't it VALUES?  

And just curious, what is god data?  Shouldn't this post be on OT?

;)

Drew

-----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 1:08 PM
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 The information contained in
this
transmission is intended only for the person or entity to which it is
addressed and may contain II-VI Proprietary and/or II-VI
BusinessSensitve
material. If you are not the intended recipient, please contact the
sender
immediately and destroy the material in its entirety, whether electronic
or
hard copy. You are notified that any review, retransmission, copying,
disclosure, dissemination, or other use of, or taking of any action in
reliance upon this information by persons or entities other than the
intended recipient is prohibited.


-- 
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
 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI BusinessSensitve material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.