×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
How does JDE do it? For example if in their code they call an RPG
subprocedure then wrap a UDF around that subprocedure and place that into
your statement. Search faq.midrange.com for UDF.
Otherwise
CREATE TABLE ROB/CONVERT
(FROMUM CHAR (2 ) NOT NULL,
TOUM CHAR (2 ) NOT NULL,
FACTOR DEC (10 , 5) NOT NULL,
PRIMARY KEY (FROMUM, TOUM),
CHECK (FROMUM <>' ' ),
CHECK (toum<>' ' ),
CHECK (FACTOR <>0 ))
INSERT...
....+....1....+....2....+.
FROMUM TOUM FACTOR
KG DK .01000
DK KG 100.00000
TN KG 1,000.00000
KG TN .00100
KG G .00100
G KG 1,000.00000
DK DK 1.00000
KG KG 1.00000
TN TN 1.00000
G G 1.00000
******** End of data ***
SELECT ITEM#, WEIGHT, UM, TOUM,
WEIGHT * FACTOR
FROM ITDTL JOIN CONVERT ON FROMUM=UM AND TOUM='TN'
....+....1....+....2....+....3....+....4....+....5....+....6....+....7
ITEM# WEIGHT UM TOUM WEIGHT * FACTOR
A 7.50000 KG TN .0075000000
******** End of data ********
Rob Berendt
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
