By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,920 Members | 1,660 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,920 IT Pros & Developers. It's quick & easy.

recordset.update method primarykey

Fary4u
100+
P: 273
Hi,

I'm attempting to update a record via the recordset.update method, However, the recordset object is defined and accesses the correct record that I want to update, as I can retrieve field values from the record.

The open string for the recordset that I'm using should allow changes:

Expand|Select|Wrap|Line Numbers
  1. ors.open "Select * from products where productname='"&request("txtname")&"'",ocon1,Adopendynamic,Adlockoptimistic
  2.  
there is no problem to update statement but when i use with primarykey & it's automatic number using the following code then : (

Expand|Select|Wrap|Line Numbers
  1. ors.open "Select * from products where productID='"&request("txtids")&"'",ocon1,Adopendynamic,Adlockoptimistic
  2.  
Microsoft JET Database Engine (0x80040E07)
Syntax error in date in query expression 'productID="89"

Is there some other "object" that needs to be defined to allow changes to the record, or something else that I am missing that causes this update to fail?

thanks 4 u reply ( Fary )
Jul 4 '09 #1
Share this Question
Share on Google+
1 Reply


jhardman
Expert 2.5K+
P: 3,405
primary key should not be in quotes:
productID=89 'correct
productID="89" 'incorrect

Let me know if this helps.

Jared
Jul 6 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.