![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Reported for Version 4.24 » View Incident Report |
![]() |
Reported By: Chris Erdal Reported On: 6/28/2006 For: Version 4.24 Build 1 |
DELETE FROM LoyersDus WHERE loyNum IN ( SELECT loyNum FROM LoyersDus, Locations WHERE (loyLocation = locNum) AND ( ((locDateFin <> NULL) AND (loyDate > CAST(CAST(EXTRACT (YEAR,locDateFin) AS CHAR(4))+'-'+CAST(EXTRACT(MONTH,locDateFin) AS CHAR (2))+'-01' AS DATE))) OR (loyDate < CAST(CAST(EXTRACT(YEAR,locDateDebut) AS CHAR(4)) +'-'+CAST(EXTRACT(MONTH,locDateDebut) AS CHAR(2))+'-01' AS DATE)) ) )
This web page was last updated on Tuesday, June 3, 2025 at 08:21 AM | Privacy Policy![]() © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |