Hello all,
I have a system that has been running for quite some time, years. It
has developed a flaw in one of the report functions that I suspect is
being caused by the data it is trying to process but I can't seem to
find what it is. Below is the relevant information, however, I would
like to provide a brief description of what is going on. The code a
fairly simple query that is part of a scan of a master table which is
generating a large report. The query runs multiple time throughout
this procedure as it gathers data for each subset of LeaseCodes for the
book that is being created. The query works fine for all of the other
data sets, approximately 300-400 other sets are processed before this
particular set. I have extracted the relevant data and populated test
tables to try and determine what is happening and I can't seem to
isolate the problem. Please let me know If I need to clarify anything
or if you need any further information. Thanks!

The Query:

q=query
answer: riv:LeaseGraph2.db

:Priv:LeaseGraph1.db|Leasecode|SummaryHID2007QSumB egDate|
check|_code!|_date!|

:AJData_Prod:Benchmarks.db|Leasecode|ProdDate|BMOi l|BMGas|
endquery
if not q.executeqbe() then errorshow() return endif

I am gathering any BMOil or BMGas data if it exists in the Benchmark
table

The table structures:
:Priv:LeaseGraph1.db |
LeaseCode A 30
SummaryHID2007QSumBegdate D
Oil N
Gas N
HHdrName A 35
RGERDHdrAlpha A 10
LeaseName A 30
Avggas N
AvgOil N

BenchMarks.db |
* LeaseCode A 30
* ProdDate D
BMOil N
BMGas N

The data set consists of a few thousand records in each table. If you
need to see it please let me know so I can email it.

Thanks
Stan

Hi Stan,

Could a low ASCII value have slipped into one of your Leasecode fields?
Pdox and the BDE has allergy attacks on chr(0).


Jim Hargan

On 27 Sep 2006 15:00:21 -0700, Corsec wrote:

I don't know why this worked, buy I did get it to work. I copied the
table containg the benchmark data, which is only updated once a year,
to a temporary table. Emptied the original and then added the records
back using the add utility. Bang everything works. I didn't change
any of the data. Any thoughts on what might have happend. Just for
reference the problem occured on any machine that tried to run the
script so it wasn't any fault due to a particular CPU.
Thanks
Stan

Your original table was corrupted and it got "fixed" in the copy-add
process?

Anders