I just spent the last hour trying to figure out what was causing sys(3054) to cause a fatal error
"Fatal error: Exception code=C0000005 @ 04/27/2002 07:40 PM. Error log file: C:\PROGRAM FILES\MICROSOFT VISUAL FOXPRO 7\VFP7err.log
Called from - old_0424_manifest line 35 {c:\morco\lvtc\files\old_0424_manifest.prg c:\morco\lvtc\files\old_0424_manifest.fxp}"
and tracked it down to several different things.
I was executing a query for a rather complicated view. The query would execute just fine and would produce the results that I wanted, but when I turned on sys(3054) and ran it, I would get the error.
1. I simplified the query down to "select < field list > from t1 where t1.date between ?pd1 and ?pd2" and started adding fields to < field list > until I got the error. Evidently there is a maximum # of fields that can be retrieved (I didn't count when it crashed) while sys(3054) is on.
2. I changed field list to "t1.*" and started adding tables to the "from" list using inner joins.
select < t1.*, t2.*, t3.* .... > ;
from t1 ;
inner join t2 on t1.field1 = t2.field2 ;
inner join t3 on t1.field3 = t3.field4 ;
.....
and it crashed again.
Before I spend any more time on this. I thought I would ask if anyone knows what is going on?
Again, the view works fine. I'm just checking the optimization on it.
TIA
Bill Morris