>It is very useful for me. but another thing is if the
>table B have a few factor in one item, is it possible to
>use this to convert to 'KG'.

Yes...
It doesn't matter how small the value is.. it will work anyway.
It is just like a REAL MATH!

So...
Do you know how to make a script for taking care of the tupples that
can not be taken care of by the TRIGGER i send to you? (I am talking
about when, for example, an insert takes place into TABLE_A and there
is no corresponding conversion tupple in TABLE_B (for the moment), OR
those tupples that you already had in TABLE_A before you started using
the TRIGGER on the same table.

Regards
/ Ali 



-----Ursprungligt meddelande-----
Fran: Choo SS [mailto:sschoo@a...]
Skickat: den 26 juli 2002 05:35
Till: sql language
Amne: [sql_language] RE: SV: RE: SV: RE: SV: RE: SV: SV: RE: SV:


Hi,

Thanks.  

It is very useful for me. but another thing is if the table B have a few
factor in one item, is it possible to use this to convert to 'KG'.  for
eg example the Table B as this:


Table B
Item		uom		uom2		factor
Item1		bottle	kg		10
Item1		box		bottle	12
Item1		carton	box		6
Item2		box		kg		0.3
Item2		carton	box		40
Item3
.
.
.