Data Analyst

<div>
<div class="content wysiwyg-content">
I have an application that is being tested by a co-worker. &nbsp;Twice he has received &quot;record out of range&quot; error. &nbsp;I have never gotten the error.<br />
<br />
I have done extensive testing and modifications on my local machine with no error. &nbsp;<br />
<br />
We are also both testing the Foxpro app &nbsp;remotely from our computers, connected to a server where the app will reside and run.<br />
<br />
Here is a screen shot of the error from my coworker:<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2019/10_w43/1434773/ckbreeds-error.png" target="_blank" title="ckbreeds-error.png (95 KB)"><img alt="ckbreeds-error.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2019/10_w43/800_1434773/ckbreeds-error.png" /></a><br />
I suspect it is an issue with the remindlabes_um(dbf) CDX file.<br />
<br />
I am copying the dbf and cdx files directly from the live environment to my test environment along with a number of other large dynamic &quot;work tables&quot; that are updated weekly. &nbsp;Do I need to reindex them each time I copy them to Test? ... Is reindexing something that needs to be done routinely?
</div>
</div>


ckbreeds-error.png

I have an application that is being tested by a co-worker.  Twice he has received "record out of range" error.  I have never gotten the error.

I have done extensive testing and modifications on my local machine with no error.  

We are also both testing the Foxpro app  remotely from our computers, connected to a server where the app will reside and run.

Here is a screen shot of the error from my coworker:



I suspect it is an issue with the remindlabes_um(dbf) CDX file.

I am copying the dbf and cdx files directly from the live environment to my test environment along with a number of other large dynamic "work tables" that are updated weekly.  Do I need to reindex them each time I copy them to Test? ... Is reindexing something that needs to be done routinely?

Record is Out Of Range Error

Visual FoxPro (VFP), and its predecessor FoxPro, is a data-centric, object-oriented, procedural, database programming language and IDE from Microsoft last released in 2007 that still has some active use due to its low cost of deployment and fairly rapid development. In 2008, Microsoft released a set of add-ons for VFP's xBase components to allow interoperability with various Microsoft technologies. It allows data processing against its native file-based data tables or database servers such as SQL Server.