Problem/Issue 4994
 
Query for PDR ID
Example: search for PDR ID 109-9999 , just enter 9999 into the entry field and press ENTER.
Open Build: Open Date: Language:
1.80.284 02.07.2002 (All)
Closed Build: Close Date: Platform:
1.90.285 23.07.2002 ALL
State: Reference PDR ID: Hotfix Rollup No.:
CLOSED    
Symptom:
ODBCDBE errors when updating Money-field (MS-Access)
Description: 
Updating a money field using
    field->amount := field->amount1 * 2
    DbCommit()
produces the runtime error:
"[22018][39][Microsoft][ODBC Microsoft Access Driver]Invalid character value
for cast specification (null)"
Solution: 
Update by statement
SQL CMD "UPDATE  SET amount = amount1 * 2 WHERE ..."
 
(C) Copyright Alaska Software Inc. 2008, All rights reserved!
Disclaimer, Limitation of Liability, no Warranty: THE INFORMATION, DOCUMENTS, FILES AND MATERIALS CONTAINED IN THIS SITE ARE PROVIDED "AS IS". ALASKA SOFTWARE DOES NOT WARRANT THE ACCURACY, ADEQUACY OR COMPLETENESS OF THIS INFORMATION AND MATERIALS; THUS EXPRESSLY DISCLAIMS LIABILITY FOR ERRORS OR OMISSIONS IN THIS INFORMATION AND MATERIALS.
WARRANTIES OF ANY KIND, IMPLIED, EXPRESSED OR STATUTORY, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF NON-INFRINGEMENT OF THIRD PARTY RIGHTS, TITLE, MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE OR RESOLVEMENT-CLAIMS, ARE DISCLAIMED.