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. James Belisle ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Alastair Burr Sent: Thursday, December 16, 2010 9:40 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: DB grid It sounds like a null isn't quite as null as you think! Check the table in the explorer - simply sorting the the appropriate column and looking at both ends (top & bottom) usually shows these things quickly. Regards, Alastair. From: Jim Belisle <mailto:[email protected]> Sent: Thursday, December 16, 2010 3:26 PM To: RBASE-L Mailing List <mailto:[email protected]> Subject: [RBASE-L] - DB grid I want to add a DB grid to an existing form. The table associated with this grid has three date fields. One date field in particular, has many NULLS because we only use it under certain circumstances. When I try attaching the DB Grid, then use the form, I get an error message saying "invalid DATE value 2418". I am using 7.6. James Belisle
