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: 4/28/2008 For: Version 1.09 Build 3 |
PROCEDURE "ShowPosten" (IN "RechnungenID" INTEGER, IN "StatusID" INTEGER) BEGIN DECLARE Result CURSOR WITH RETURN FOR Stmt; PREPARE Stmt FROM 'SELECT P.*, if (ziffer like ''#%'' then ''Abzug Einzelziffern wegen Höchstwert '' + ziffer else text ) as Text from Posten P left outer join Ziffern Z on P.Ziffer = Z.Ziffer where RechnungenID = ? order by Datum, orderID'; OPEN Result using RechnungenID ; 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 |