Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Java Client POS] (No Category)minorN/A2008-12-07 23:022008-12-07 23:02
ReporterglobeoneView Statuspublic 
Assigned To 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabaseAnyJava versionSun 6
OS VersionUbuntu 8.10 2.6.27-9-serverDatabase versionMySQL 14.12 Distrib 5.0.67Ant version
Product Version2.20SCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release

0006393: Ability to Auto Increment the Product Reference Code

DescriptionIn 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
Steps To Reproducecreate 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 SolutionAdd an ability to auto increment the reference number
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
There are no notes attached to this issue.

- 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)

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker