Jim - check your date settings in the database to ensure that you have
the date set properly. Note that the sequence has only a two digit year
in it. Here is an example. Note the sequence string.
R>show date
DATE format MM/DD/YYYY
DATE sequence MMDDYY
Century threshold YEAR is 89
Default CENTURY is 19
On 16/12/2010 9:04 AM, Jim Belisle wrote:
Alastair,
I sorted all three date columns in that table, corrected anything that
looked remotely odd, and tried again.
I still get the same error. I also put a date format in the table
settings just to be safe and that made no difference.
This is a slave table.
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================