Openbravo Issue Tracking System - Java Client POS
View Issue Details
0006393Java Client POS(No Category)public2008-12-07 23:022008-12-07 23:02
30Ubuntu 8.10 2.6.27-9-server
0006393: Ability to Auto Increment the Product Reference Code
In Administration -> Stock -> (New Record): Reference
I would like to be able to auto increment this value every time a value is entered in the Name field.

I have tried to modify the REFERENCE column of the PRODUCTS table to INTEGER AUTO_INCREMENT but this returns an error when filling in the Name field.

Error is:
java.sql.SQLException: Incorrect integer value: " for column 'REFERENCE' at row 1
create a blank openbravopos database in MySQL
start openbravopos and let it create the database
create 1 product without a reference number
close openbravoPOS
modify the REFERENCE column in the PRODUCTS table to INTEGER AUTO_INCREMENT
reopen openbravoPOS
go back to Admin -> Admin -> Stock -> Products
Add a second product without a reference number
Exception as in the Description.
Add an ability to auto increment the reference number
No tags attached.
Issue History
2008-12-07 23:02globeoneNew Issue
2008-12-07 23:02globeonesf_bug_id0 => 2404567
2012-11-07 09:40priyamCategory01 - General => (No Category)

There are no notes attached to this issue.