Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 1.07 » View Incident Report |
Minor |
Reported By: Harry de Boer Reported On: 11/12/2007 For: Version 1.06 Build 1 |
SELECT extract(month from Datum) AS maand, SUM(Bedrag) AS bedr INTO memory tmpJTOV FROM contracten, contractregels WHERE extract(year from Datum_van) = 2005 AND contracten.id_contract = contractregels.id_contract AND Object_of_Artikel = 'O' AND geannuleerd is Null GROUP BY maand; is converted as SCRIPT () BEGIN EXECUTE IMMEDIATE 'SELECTextract(month from Datum) AS maand,SUM(Bedrag) AS bedrINTO memory tmpJTOVFROM contracten, contractregelsWHERE extract(year from Datum_van) = 2005AND contracten.id_contract = contractregels.id_contractAND Object_of_Artikel = ''O''AND geannuleerd is NullGROUP BY maand';
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 |