![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Reported for Version 3.02 » View Incident Report |
![]() |
Reported By: Michael Fullerton Reported On: 10/4/2001 For: Version 3.02 Build 1 |
SELECT * FROM Bookings WHERE Resource = 'I' AND ( ([Date] = '2001-10-05' AND UPPER([Freq]) = 'S') OR (UPPER([Freq]) <> 'S' AND '2001-10-05' <= [EndDate]) ) when you change the SQL to this it works SELECT * FROM Bookings WHERE Resource = 'I' AND ( ([Date] = '2001-10-05' AND UPPER([Freq]) = 'S') OR (UPPER([Freq]) <> 'S' AND [EndDate] >= '2001-10-05') )
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |