Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.18 » View Incident Report |
Serious |
Reported By: Accowin [LBRP] Reported On: 10/23/2014 For: Version 2.18 Build 1 |
When running query: SELECT * FROM AlgRek r INNER JOIN History h ON h.AlgRek=r.Referte INNER JOIN AlgTot t ON (t.Referte,t.jaar,t.Periode)=(r.Referte,:pJaar2,9999) WHERE (h.Jaar=:pJaar2 AND h.Periode>=:pBegin AND h.Periode<=:pEinde) and r.Referte IN (SELECT referte FROM AlgRek WHERE prive <> 0) With param values pJaar2=2013, pBegin=0, pEinde=4 we get 2 records. If we run the same query but change in the SQL the first pJaar2 by 2013 then we get 6 rows. The last result is the correct one.
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 |