>I've noticed some strange sql behavior that maybe someone knows a fix for. I was getting net sales information by state and the sql was something like:
>
>select state, sum(sale) from sales group by state
>
>note: there were a few records where the state was blank and set exact was on
>
>The result of each state pulled in the sales from the blank state also. The each state was overstated by the sum of the blank state. This didn't always happen. It happened when I ran the query 2 or 3 times. If I exited foxpro and then come back in and reran the query it would work properly. Any idea of how to fix this problem
>Thanks
My suggestion does not directly involve your query. When the application writes the rows into the table, is there any validation ??? From what you are saying, I would work from a standpoint of why do I have blank rows in my data rather than what's wrong with the query.
Regards,
Jason
Jason Tryon
Senior Systems Analyst / Technical Lead
eBusiness / iPage