At 06:46 PM 3/3/2005, Dave Gallup wrote:
I have a table which contains a DATE column. The table
appears corrupted since it now sorts improperly on date.
Dave,
First, let me take this opportunity to welcome you to the
R:BASE World!
In reference to your table with improper sort on DATE, I
recommend that you check the DATE settings after CONNecting
the database in question.
Here's how:
01. Start RBG7
For latest updates: http://www.rbase.com/rbg7updates
02. CONNect dbname
At the R> prompt:
SHOW DATE
Typical DATE settings:
DATE format MM/DD/YYYY
DATE sequence MMDDYY
Century threshold YEAR is 50
Default CENTURY is 19
03. Once you set the DATE FORMAT, SEQUENCE, YEAR and CENTURY
accordingly, try the following test:
TALLY datecolname FROM tablename
Notice any oddity?
04. If all fails, try to RELOAD the database or use R:Scope 7.5
http://www.rbase.com/products/rscope
Should you need further help, feel free to ask.
Very Best R:egards,
Razzak.
