|
| |
|
|
MikeF
Posts: 50
From: New York, USA
Status: offline
 |
Updating a counter - 2/27/2001 22:30:00
I have a counter within my ACCESS 97 D.B. that I need to increment. The following code is not working:SQLStmt = "UPDATE boards SET "
SQLStmt = SQLstmt & " number-of-posts='" & number-of-posts + 1 & "'"
SQLStmt = SQLStmt & " WHERE subject='" & Subject & "'"
SQLStmt = SQLStmt & " And msgboard='" & Msgboard & "'" All help is appreciated!
|
|
|
|
Spooky
Posts: 26598
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Updating a counter - 2/28/2001 18:48:00
Youll need to open the recordset first, get the value of number-of-posts (which should be numeric) and then add the new valueeg : objRs(11)= objRs(11) + "1"
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
