Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.03 » View Incident Report |
Serious |
Reported By: Don Potts Reported On: 6/14/2010 For: Version 2.03 Build 14 |
WORKS: SELECT CLAIM."Print" FROM CLAIM WHERE CLAIM.PIN IN (SELECT DISTINCT ALLPATI.PIN FROM ALLPATI WHERE CLAIM.PIN=ALLPATI.PIN AND ALLPATI."Type" = 'MM') AND CLAIM."Date" >= :date1 AND CLAIM."Date" <= :date2 AND CLAIM.Remaining > 0.00 AND CLAIM.Policy1 like :pol1 DOES NOT WORK: SELECT CLAIM."Print" FROM CLAIM WHERE CLAIM.PIN IN (SELECT DISTINCT ALLPATI.PIN FROM ALLPATI WHERE CLAIM.PIN=ALLPATI.PIN AND ALLPATI."Type" = :datype) AND CLAIM."Date" >= :date1 AND CLAIM."Date" <= :date2 AND CLAIM.Remaining > 0.00 AND CLAIM.Policy1 like :pol1 PARAM NAME: datype TYPE: varchar VALUE: MM MODE: IN
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 |