Razzak, Yes, I agree things have changed, thank you for the tip - I will try and do better in future.
However, I have updated all the null dates, checked these with the Tally command as suggested and tried editing again. I still get the same error, and I note that when I change one column in the table some erroneous (ie other than A-Z and numbers) characters appear in other columns (but as the Save cannot be executed, these are only temporary). I have since found that if I delete some columns the error disappears (but unfortunately so does the data) - I have just to determine which is the critical column (if there is one). I tried deleting the first row in the table after the stray characters appeared, in case it was corrupted, but they just moved to the next row, so that was that. The date format & sequence is as follows:- R>show date DATE format dd/mm/yyyy DATE sequence DDMMYYYY Century threshold YEAR is 0 Default CENTURY is 20 (I have submitted details of the problem as suggested but I suspect someone needs to look at the table in question to see exactly what is wrong with what I have done.) Thanks for your assistance and suggestions. Regards John Docherty -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Friday, 24 June 2005 1:22 p.m. To: RBG7-L Mailing List Subject: [RBG7-L] - Re: 7.5 Edit Data in Grid or Row At 08:34 PM 6/23/2005, John Docherty wrote: >I have tried editing the table with the latest build >of 7.1 and now get the error message '00/00/0000' is >not a valid date. I have date columns with dates yet >to be entered (and hence are showing as nulls) - could >this be something to do with the problem ? John, See what happens when you use the latest updates! Now you need to check the DATE FORMAT/SEQUENCE of your database. Older versions of R:BASE did not care how the data was stored or displayed, but the latest versions will keep you on your toes. No excuses <g> A simple test is to TALLY the datecolumn at the R> prompt. This exercise will tell you the exact data and the rows with invalid dates in date columns. Do this for all columns with dates, one at a time. Use the UPDATE command to fix those invalid dates. That's all there is to it! Good luck! Very Best R:egards, Razzak.
