BETWEEN and <= not selecting end points (AREV Specific)
At 28 OCT 2002 09:18:16AM Joe Nirta wrote:
I'm having an issue on AREV 3.1 single user.
The command LIST WITH ORDERED.DATE BETWEEN "01 AUG 02" AND "31 AUG 02" does not list anything on the end point dates, it only lists dates from "02 AUG 02" thru "30 AUG 02". I've tried replacing the BETWEEN with ]= and WITH ORDERED.DATE=01 AUG 02", it does return rows!
Thanks
joe
At 28 OCT 2002 10:16AM Dave Harmacek wrote:
Use FROM TO instead of BETWEEN. Literally…
At 28 OCT 2002 11:06AM Joe Nirta wrote:
Still having the same problem…thanks
At 28 OCT 2002 12:21PM Victor Engel wrote:
What kind of conversion/justification do you have on the date field and the key field of the file? What do your keys look like? What happens when you try
LIST WITH ORDERED.DATE GE "01 AUG 02" AND WITH ORDERED.DATE LE "31 AUG 02"
Have you verified that the data stored for these dates is in internal format and not external format?
What if you type:
LIST WITH ORDERED.DATE FROM 12632 TO 12662
At 28 OCT 2002 01:04PM Joe Nirta wrote:
Data conversion is (D) and I've checked the internal data. It is indeed in internal date format…12655 etc.
I've tried GE, ]=, =]..all yield same results. I've tried building a SELECT list, then running LIST.
At 28 OCT 2002 02:18PM Don Miller - C3 Inc. wrote:
What version of AREV 3.x? There were some errors in 3.x that were fixed in 3.12 .. I think in ICONV / OCONV on dates, if I remember correctly. Also, are your date fields RIGHT justified???
Don Miller
C3 Inc.
At 28 OCT 2002 04:01PM Victor Engel wrote:
(D) would be the input conversion. The relevant conversion here is actually the output conversion.
At 28 OCT 2002 07:36PM Richard Hunt wrote:
Joe,
I have just tested a select statement…
SELECT SA WITH DATE BETWEEN "1-4-0" AND "1-11-0"
That statement picked up all items perfectly, with dates of 1-4-0 thru 1-11-0, and all dates between also (inclusive).
My dictionary item for "DATE" has "output format" of "D2/" and "validation pattern" of "(D)".
I know this does not really help you, and I thought you might want to know that it works for me.
Oh by the way… I do not have "DATE" indexed.
At 29 OCT 2002 09:23AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
Have you tried narrowing the selection down, moving the end points until you find one that works?
Also, BETWEEN is exclusive, and FROM…TO is inclusive.
World Leaders in all Things RevSoft
At 29 OCT 2002 09:48AM Joe Nirta wrote:
Thanks for everyone's help. I have the system installed on another machine and it works there! I re-installed AREV 3.1 over the existing non-working sytem and it now works as well. ???
thanks
joe
At 30 OCT 2002 11:47AM Matt Sorrell wrote:
Quoth Sprezz:
Also, BETWEEN is exclusive, and FROM…TO is inclusive
I use BETWEEN quite a bit in some of my routines, and it has always been inclusive . . .
Am I just lucky or am I missing something?
At 31 OCT 2002 08:48AM Don Miller - C3 Inc. wrote:
M@:
I think you're right (at least for AREV from 2.1x onward). I think REV-G and early versions of AREV were EXCLUSIVE for the BETWEEN construct. Anyway a test today indicates that BETWEEN is INCLUSIVE in AREV 3.12.
Don M.
At 31 OCT 2002 10:08AM Aaron Kaplan wrote:
I was having a moment…I was probably thinking of the BTREE.EXTRACT and the between/range difference.
That's my story, and I'm sticking to it. So there. hrump.
At 31 OCT 2002 11:26AM Matt Sorrell wrote:
Quoth Aaron:
I was having a moment…
Are you better now? Do you need a tissue or a glass of water?
At 31 OCT 2002 12:39PM Don Miller - C3 Inc. wrote:
Or a laxative ..
Sometimes suffers from premature exclamation.
Don M.