Date: prev next · Thread: first prev next last
2018 Archives by date, by thread · List index


Le 23/08/2018 à 14:01, lunixbox a écrit :

Hi,

I am assuming that you're not using dbase as your database engine, and
that you just abbreviated database to dbase in the title of your
message. The dBase format supported by LibreOffice is rather limited in
terms of functionality, so I would hope that you are using another db
engine instead, such as the actual "per default" hsqldb engine included
with LO.

Looking for advice, using the scanned  bar code give the product, then i
want to use Box-ID to add a THT.Date. All in that box is that date. Now
i pull some hair to think of a way for the form-OUT or IN  that has the
(scanned) product to add the Box-ID so the total is + or - 1. So just
item,s IN and OUT

I'm not really sure I understand how you want a BoxID, which I presume
is a barcode, and therefore probably a text string, to be added to a
date string held in the THT.Date field, and arrive at a result of +1 or -1.

Again, if I have understood correctly, you want a result of a
calculation to be displayed in a form control that can be expressed as
either +1 or -1. You could in that case just as equally choose 0 or 1,
and then use a boolean or binary field (generally, these are TINYINT(1)
or CHAR(1) fields, to hold the result.

However, you still need to determine when the result of your addition
should be 0/1 or +1/-1 - this can only be achieved by calculation. This
other calculation could be achieved:

- by macro;
- by using a constraint (if the db engine supports that kind of constraint);
- by using a trigger (if the db engine supports that kind of trigger).

Alex



-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.