I have a new database that is based on a tried and tested formula of mine, with the exception of one or two new bits.
Everything seemed to be going well, until a couple of days ago (ironically, when this site was down). The problem was this:
When I input data into the database manually everything was perfect.
When I imported data, I got an error message and the whole thing crashed, but I only got an error message after running a report. In other words: I import data, open the customer details screen, open other forms - no problem. I run a report (not a specific report, it happened with a lot of them), close the report, open the customer details screen and crash - every time.
By a process of elimination I looked at everything, all the code etc, I re-did all the reports, and then compared the data that I input manually, against the data imported. The only difference was that with the manually input data, the default for the field called "value" (the default was set at 0) was over-ruled by the input form which returned a null value.
The strange thing was that the reports that seemed to trigger the error didn't even access the table with the discrepancy. I deleted teh default value (0) and everything works fine again.
However, I am still not happy that there is not something going on that I am unaware of, and as this is an important project for me, I was wondering if anyone had any ideas.
PS - Sorry if this is a bit long-winded
Everything seemed to be going well, until a couple of days ago (ironically, when this site was down). The problem was this:
When I input data into the database manually everything was perfect.
When I imported data, I got an error message and the whole thing crashed, but I only got an error message after running a report. In other words: I import data, open the customer details screen, open other forms - no problem. I run a report (not a specific report, it happened with a lot of them), close the report, open the customer details screen and crash - every time.
By a process of elimination I looked at everything, all the code etc, I re-did all the reports, and then compared the data that I input manually, against the data imported. The only difference was that with the manually input data, the default for the field called "value" (the default was set at 0) was over-ruled by the input form which returned a null value.
The strange thing was that the reports that seemed to trigger the error didn't even access the table with the discrepancy. I deleted teh default value (0) and everything works fine again.
However, I am still not happy that there is not something going on that I am unaware of, and as this is an important project for me, I was wondering if anyone had any ideas.
PS - Sorry if this is a bit long-winded
