It is obvious that the offending table is one called BOLHeader. When I remove it as a slave table, there is no error message.
The form I am trying to change is my Order edit form. I am trying to add a DBGrid so I can see all the BOL created for any order since we drop ship some items on different days. 1) Thus far I have done an UNLOAD RELOAD and no errors showed up there. 2) I have gone into the table itself and sorted all three date columns. I changed some dates that were not correct but all NULLS look like NULLS. 3) I have tried putting the EQNULL code into the on before start EEP of the form and on the line just before calling the form. This did not eliminate the error message. Even when I added the DBGRID itself, no information showed up on the grid. The common column is Control#. James Belisle ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of John Engwer Sent: Thursday, December 16, 2010 10:30 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: DB grid James, Try SET EQNULL ON before you access the form. John From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Thursday, December 16, 2010 10:27 AM To: RBASE-L Mailing List 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
