>Hi!
> I am faced with a frustrating and hard to figure out problem...
>
> Here's the problem...
> Some clients use two program which access
> the same DBF file called PDMLOG.DBF
>
> One client program inserts records into the PDMLOG
> and then the server application reads it and transfers it to AS400 if necessarry.
>
> Most of the time it works but sometimes when the records
> get inserted into the table in the client program
> the server program can't see these new records.
>
> I opened up the table in foxpro and noticed the
> following.
>
> In the application there are 50050 records with some data I put in to test...
> I do a tableupdate(.t.)
>
> But in foxpro there is only 50000 records.
>
> When I close the program the data is lost.
> When I come back in only 50000 records remain.
>
> So I drop the CDX file and reindex it.
> It works for a while and then the problem happens again.
>
>The table has 8 out of its 16 columns indexed and only has insert activity in it no deleted, updates.
>
>Is this a performance problem or potential problem here.
>I know about Oracle as a DBA and I would deffinetly
>critize this number of index on a table of this type.
>
>Problem is all the foxpro code does stuff like.
>set order to tag blah
>seek blahblah
>
>Could this be the problem.
>Any ideas???
Eight index tags is not a problem. Neither is SEEK. There are several possibilities. On my web page is a KB article that discusses data corruption. It should give you some ideas to look at.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer