« Request title search problems | Main | Changing Service Type »

SQL error

There is a known issue which causes an SQL error to occur. If the UPC character string is more than 14 digits this error occurs. Most UPC codes are entered either as 10, 11 or 12 numeric digits. Sometimes there is additional information which causes the UPC field to run longer than 14 characters, such as the additional information (set) or vol. 1. The SQL error will go away if you delete all info after the numeric UPC in the UPC field, Authority field and Key field. The issue has been forwarded to OCLC PICA development to fix.

Posted by Nick on March 26, 2007 2:14 PM |

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)