Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Addressed for Version 3.08 » View Incident Report |
Serious |
Reported By: J. Pieter Vos Reported On: 3/21/2002 For: Version 3.07 Build 1 |
select C.CodiArticle, Sum(C.Unitats) as Compra, Sum(Cast("" as Float)) as Venda, Min(C.Preu) as Minim,Max(C.Preu) as Maxim,Avg(C. Preu) as Mitg into MEMORY llisstock from "fwcal-RE002002.dat" C,"fwcac-RE002002.dat" CC Where CC.NumeroAlbara = C.Numero and CC.Anulat = False and CC.CodiStatus IN ( "04" , "00" , "50" , "PG" , "EG" , "FG" , "05" , "RG" , "06" , "01" , "07" , "CO" , "UI" ) union all select V.CodiArticle, Cast("" as Float) as Compra , V.Unitats,Cast("" as Float) as Minim,Cast("" as Float) as Maxim,Cast("" as Float) as Mitg from "fwval-RE002002.dat" V,"fwvac-RE002002.dat" VV Where VV.NumeroAlbara = V.Numero and VV.Anulat = False and VV.CodiStatus IN ( "04" , "00" , "50" , "PG" , "EG" , "FG" , "05" , "RG" , "06" , "01" , "07" , "CO" , "UI" ) Group by CodiArticle Order by CodiArticle; select CodiArticle , Sum(StockInicial) as SI into MEMORY StockIni from "fwmagart-RE002002.dat" Where Actiu = True Group by CodiArticle; Select * from MEMORY llisstock P LEFT OUTER JOIN MEMORY StockIni P2 ON (P.CodiArticle = p2.CodiArticle)
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |