Re: [GENERAL] how to make select for multiunit

2012-01-15 Thread Misa Simic
: SELECT name, to_myUofM(qty).KRT, myUofM(qty).PAK, myUofM(qty).PCS FROM stocks Kind Regards, Misa Sent from my Windows Phone -- From: Rene Romero Benavides Sent: 15/01/2012 05:26 To: pgsql-general@postgresql.org Subject: Re: [GENERAL] how to make select for multiunit

Re: [GENERAL] how to make select for multiunit

2012-01-14 Thread Rene Romero Benavides
On 01/14/2012 09:22 PM, plasmasoftware net wrote: hello ... i have stock table all stock in smallest unit ( PCS ) i have stock table like this name qty unit PCA 20 PCS MOUSE 25 PCS i have table unit 1 KRT = 12 PAK 1 PAK = 10 PCS how to make select to display report stok in dbGRID like

[GENERAL] how to make select for multiunit

2012-01-14 Thread plasmasoftware net
hello ... i have stock table all stock in smallest unit ( PCS ) i have stock table like this name qty unit PCA 20 PCS MOUSE 25 PCS i have table unit 1 KRT = 12 PAK 1 PAK = 10 PCS how to make select to display report stok in dbGRID like this : PCA 2 KRT 0 PAK 0 PCS MOUSE 0 KRT 2 PAK 1 PC