Close Tables All
Create Cursor ilaclar(ilaclar c(10),giren I,cikan I,stok I)
Insert Into ilaclar(ilaclar,giren,cikan,stok) Values("aspirin",0,0,0)
Insert Into ilaclar(ilaclar,giren,cikan,stok) Values("zakkum",0,0,0)
Insert Into ilaclar(ilaclar,giren,cikan,stok) Values("zikkim",0,0,0)
Create Cursor fatura(ilaclar c(10),miktar I)
Create Cursor kullanilan(ilaclar c(10),miktar I)
Insert Into fatura(ilaclar,miktar) Values("aspirin",10)
Insert Into fatura(ilaclar,miktar) Values("zakkum",5)
Insert Into fatura(ilaclar,miktar) Values("zikkim",7)
Insert Into kullanilan(ilaclar,miktar) Values("aspirin",2)
Insert Into kullanilan(ilaclar,miktar) Values("zakkum",3)
Insert Into kullanilan(ilaclar,miktar) Values("zikkim",4)
Insert Into kullanilan(ilaclar,miktar) Values("zakkum",1)
Insert Into kullanilan(ilaclar,miktar) Values("zikkim",1)
Select ilaclar,Sum(miktar) As giren From fatura Group By 1 Into Cursor crsGiren NOFILTER
Select ilaclar,Sum(miktar) As cikan From kullanilan Group By 1 Into Cursor crsCikan NOFILTER
Update ilaclar Set ;
giren = crsGiren.giren,;
cikan = crsCikan.cikan,;
stok = crsGiren.giren - crsCikan.cikan;
from ilaclar;
INNER Join crsGiren On crsGiren.ilaclar = ilaclar.ilaclar;
INNER Join crsCikan On crsCikan.ilaclar = ilaclar.ilaclar
Select ilaclar
BROWSE TITLE "Stok Durum"