Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 1.09 » View Incident Report |
Minor |
Reported By: Uli Becker Reported On: 3/25/2008 For: Version 1.08 Build 1 |
BEGIN DECLARE Mahngebuehr2 Float Default 0; DECLARE Mahngebuehr3 Float Default 0; DECLARE Condition VarChar; DECLARE Result CURSOR FOR Stmt; Prepare Stmt FROM 'select Mahngebuehr2, Mahngebuehr3 from optionen'; Open Result; Fetch First FROM Result(Mahngebuehr2, Mahngebuehr3) INTO Mahngebuehr2, Mahngebuehr3; Close Result; Prepare Stmt from 'Update Rechnungen set Mahnung1 = Current_Date where RechnungenID in (select RechnungenID from Mahnungen where RechnungenID = ? and Mahnstufe = 1)'; Execute Stmt using RechnungenID; Prepare Stmt from 'Update Rechnungen set Mahnung2 = Current_Date, Mahngebuehr2 = ' + Cast(Mahngebuehr2 as VarChar) + ' where RechnungenID in (select RechnungenID from Mahnungen where RechnungenID = ? and Mahnstufe = 2)'; Execute Stmt using RechnungenID; Prepare Stmt from 'Update Rechnungen set Mahnung3 = Current_Date, Mahngebuehr3 = ' + Cast(Mahngebuehr3 as VarChar) + ' where RechnungenID in (select RechnungenID from Mahnungen where RechnungenID = ? and Mahnstufe = 3)'; Execute Stmt using RechnungenID; Prepare Stmt from 'Update Rechnungen set Inkasso = Current_Date where RechnungenID in (select RechnungenID from Mahnungen where RechnungenID = ? and Mahnstufe = 4)'; Execute Stmt using RechnungenID; /* Mahnungen für Protokoll bearbeiten */ Execute Immediate 'Update Mahnungen set Mahnung1 = Current_Date where Mahnstufe = 1'; Execute Immediate 'Update Mahnungen set Mahnung2 = Current_Date where Mahnstufe = 2'; Execute Immediate 'Update Mahnungen set Mahnung3 = Current_Date where Mahnstufe = 3'; Execute Immediate 'Update Mahnungen set Inkasso = Current_Date where Mahnstufe = 4'; END
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 |