Razzak, Sorry, but I think I did what you suggested - viz identify that there were rows with null dates in the DATE columns using Tally at the R>, Update these at the R> using something like UPDATE systems set COM_DATE='1/1/2000' where COM_DATE fails etc, check again with Tally at R> to make sure all dates were valid, and then I try EDIT ALL IN SYSTEMS, which is where the error occurs.
Regards John Docherty -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Friday, 24 June 2005 2:21 p.m. To: RBG7-L Mailing List Subject: [RBG7-L] - Re: 7.5 Edit Data in Grid or Row At 09:52 PM 6/23/2005, John Docherty wrote: >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). John, Please read my earlier e-mail in it's entirety. I suggested that you try the TALLY at the R> prompt and then use the UPDATE command to fix the date column(s), not using the data browser. Very Best R:egards, Razzak.
