Openbravo Issue Tracking System - Java Client POS | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0006393 | Java Client POS | (No Category) | public | 2008-12-07 23:02 | 2008-12-07 23:02 |
| Reporter | globeone | ||||
| Assigned To | |||||
| Priority | normal | Severity | minor | Reproducibility | N/A |
| Status | new | Resolution | open | ||
| Platform | OS | 30 | OS Version | Ubuntu 8.10 2.6.27-9-server | |
| Product Version | 2.20 | ||||
| Target Version | Fixed in Version | ||||
| Regression date | |||||
| Regression introduced by commit | |||||
| Regression level | |||||
| Review Assigned To | |||||
| OBNetwork customer | |||||
| Support ticket | |||||
| Regression introduced in release | |||||
| Summary | 0006393: Ability to Auto Increment the Product Reference Code | ||||
| Description | 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: NOT_00_0000 com.openbravo.basic.BasicException: java.sql.SQLException: Incorrect integer value: " for column 'REFERENCE' at row 1 | ||||
| Steps To Reproduce | 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. | ||||
| Proposed Solution | Add an ability to auto increment the reference number | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2008-12-07 23:02 | globeone | New Issue | |||
| 2008-12-07 23:02 | globeone | sf_bug_id | 0 => 2404567 | ||
| 2012-11-07 09:40 | priyam | Category | 01 - General => (No Category) | ||
| There are no notes attached to this issue. |