Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.08 » View Incident Report |
Serious |
Reported By: Fernando Dias Reported On: 1/17/2012 For: Version 2.07 Build 1 |
Parameter values: cf2 = 1137 di2 = 2011-01-01 cf1 = 1137 di1 = 2011-01-01 df1 = 2011-12-31 Query: SELECT * FROM ( SELECT CAST(NULL AS DATE) AS DataMov, 'Saldo Anterior' AS Descricao, '' AS TipoDoc, CAST(NULL AS INTEGER) AS NumReg, '' AS NumDoc, SUM(ValorMovCS) AS Valor , CAST(NULL AS INTEGER) AS Diario, CAST(NULL AS INTEGER) AS NumLanc FROM MovFor WHERE CodFornecedor = :cf2 AND DataMov < :di2 UNION ALL SELECT DataMov, Descricao, TipoDoc, NumReg, NumDoc, ValorMovCS, Diario, NumLanc FROM MovFor WHERE CodFornecedor = :cf1 AND DataMov >= :di1 AND DataMov <= :df1 ) AS TmpTbl
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |