| Author |
 Topic  |
|
|
ngaisteve1
Junior Member
Malaysia
241 Posts |
 Posted - 06 August 2003 : 05:04:23
|
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Query-based update failed because the row to update could not be found.
/inventory_system/issue_requisition_issue_selected.asp, line 40
I narrow down the problem and it's a bit weird. When comment this line of code below, it works.
rs_issue("date_issued") = DatePart("YYYY", Date) & "/" & Right("0" & DatePart("M", Date),2) & "/" & Right("0" & DatePart("D", Date),2)
But, the weird thing is I have another file which just exactly the same line of code. This line of code intend to create a transaction log file.
All help really appreciated. |
|
|
gelliott
Junior Member
USA
268 Posts |
Posted - 06 August 2003 : 12:30:26
|
Your DatePart functions look correct to me - could be a data type mismatch problem. You are returning a text string to rs_issued("date_issued") - did you mean to return a date datatype? Like this:
rs_issue("date_issued") = DateValue(DatePart("YYYY", Date) & "/" & Right("0" & DatePart("M", Date),2) & "/" & Right("0" & DatePart("D", Date),2))
Also, perhaps your system date format settings prevent text date strings from recognizing dates in a YYYY/M/D format, although I think this is less likely. To simply rule it out, you could try:
rs_issue("date_issued") = Right("0" & DatePart("M", Date),2) & "/" & Right("0" & DatePart("D", Date),2) & "/" & DatePart("YYYY", Date) |
* The optimist says the cup is half full. The pessimist says it's half empty. But the engineer knows the truth - the cup's design is incorrectly sized.  |
 |
|
|
ngaisteve1
Junior Member
Malaysia
241 Posts |
Posted - 06 August 2003 : 22:28:30
|
| Still can't. Same error. |
|
|
| |
Topic |
|
|
|
Topic Locked
