ADS error 7038

[merlin511]

had to reduce the record number of a large file. Serveur is a nt 4 workstation running advantage database server. all stations are 98se. After the pack command the application give an dos error 7038. I rebuilt all index from scratch and try copy and recopy file. The problem is still there.
Anyone know how to fix this problem ???? Never had this problem prior the resizing.

 

[RHankinsJr]

I have never used ADS, but what are you doing when you get this error? Is it possible that within your code you are attempting to reposition the record number to a position that is no longer in the file?

I have had a similar problem as described at the below link, where I was writing the record number out to the database as the link back to the other table, then after a pack everything got twisted up.

Just an idea, sorry I couldn't be of more help.

Desc of error:

http://www.clipx.net/ng/ads/ng818fb.php

--

Richard L. Hankins Jr.
Senior Programmer
Auction Services, Inc.

 

[etoma]

Advantage error 7038 means the record number referenced by the index does not exist in the DBF file. I see it in a program that filters a large database and copies the resulting dataset to a new file. The new index contains, somehow, the record numbers of the larger database, and can produce this error when you run anything on the new file. The only solution I've found is to reindex the file after doing the copy.