TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Jeff C
NA
9
0
Update issues
Sep 29 2010 7:26 PM
Hello,
I am using VS2008 C#, attempting to use ADO.NET to update a MS Access Database.
My table is called testtable, it has 2 columns: DatePaid, AmountPaid. DatePaid is a date field, and Amountpaid is a currency field.
When I run my command it doesn't update the record. It doesn't error, simply nothing happens. It works fine to create tables, delete tables, delete entries, just update won't work properly. I'm sure I got something mixed up.
My Query at runtime is: UPDATE testtable SET DatePaid=20/08/2010, AmountPaid=900 WHERE DatePaid=18/08/2010 AND AmountPaid =250
I have tried utilizing ' ' around the values, and switching the dates/values around and it still won't update an existing record. I'm wanting to change the DatePaid Field to 20/08/2010 and the AmountPaid to 900
I'm not sure where it's going wrong.
Any help would be appreciated.
Reply
Answers (
1
)
Closing form
Looking for a training center to learning advanced workflow 4.0