| Subject | Barcode into SQL statement |
|---|---|
| Author | majstoru |
| Post date | 2006-09-19T12:27:33Z |
Hi,
I have a specific request from few my clients to generate internal
barcodes into some tables.
That is not a big problem because I have a rulem for this action and
I get 12 digits from EAN13 barcode standard, BUT checksumm is a
problem.
Math is: all even numbers are put in sum and that sum is multiply
with 3 and all odd nubers are put in sum and add to a previous
result. Aftre that you must find first nuber delimited with 10 and
difference between that nuber and sum nuber are checksum.
So is there any way to make math like that with SQL statement,
please? :-?
I have a specific request from few my clients to generate internal
barcodes into some tables.
That is not a big problem because I have a rulem for this action and
I get 12 digits from EAN13 barcode standard, BUT checksumm is a
problem.
Math is: all even numbers are put in sum and that sum is multiply
with 3 and all odd nubers are put in sum and add to a previous
result. Aftre that you must find first nuber delimited with 10 and
difference between that nuber and sum nuber are checksum.
So is there any way to make math like that with SQL statement,
please? :-?