I thought I'd done this before but I can't seem to figure out what I'm doing wrong. I'm trying to evaluate if a time is between two values. I've tried SELECT COUNT(*) INTO vChkCnt INDIC ivChkCnt + FROM Appointment + WHERE AppointmentStart + BETWEEN .vStartTime + AND .vEndTime
but I get "no rows found" even when I know there are some. Using 9.0.4.11124 Jan -----Original Message----- From: "A. Razzak Memon" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 24 Nov 2010 15:10:00 -0500 Subject: [RBASE-L] - Introducing R:Docs 9.1 Wednesday, November 24, 2010 To All Users of R:BASE eXtreme 9.x: R:Docs 9.1 is now available! This compiled version of R:Docs 9.1 is available FREE to all registered users of R:BASE eXtreme 9.x (32/64). http://www.rupdates.com/rbg90_32 http://www.rupdates.com/rbg90_64 R:Docs 9.1 includes all updated PROPERTY, GETPROPERTY, PRINT, GATEWAY commands and more, that are supported in R:BASE eXtreme 9.1 for Windows. New CHOOSE Builder Plugin is also implemented to take advantage of additional OPTIONS in R:BASE eXtreme 9.1. This eXclusive Edition of R:Docs 9.1 is also stuffed with the following additional options: . Lookup R:BASE Error Messages . Search Error Number . Search Error Message Text Highlights of R:Docs 9.1: . PROPERTY Command - Build Syntax for PROPERTY Command - Print PDF Manual of PROPERTY Command - Print PDF Manual of PROPERTY Command (with TOC) . GETPROPERTY Command - Build Syntax for GETPROPERTY Command . CHOOSE Command - Build Syntax for CHOOSE Command - Templates for CHOOSE Command . Command Line GATEWAY Export - Build Syntax for Command Line GATEWAY EXPORT . Command Line GATEWAY Import - Build Syntax for Command Line GATEWAY IMPORT . DIALOG Command - Build Syntax for DIALOG Command - Build Syntax for DIALOG with Buttons Command - Templates for DIALOG Command . PAUSE Command - Build Syntax for PAUSE Command - Templates for PAUSE Command . PRINT Command - Build Syntax for PRINT Command - Templates for PRINT Command - Templates for PRNSETUP Command . #WHERE Clause - Templates for #WHERE Clause . Lookup R:BASE Error Messages - Search Error Number - Search Error Message Text Hope you all take advantage of this valuable tool! Very Best R:egards, Razzak.
