Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Candidate index contain duplicate record
Message
From
04/02/2002 10:57:09
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Candidate index contain duplicate record
Miscellaneous
Thread ID:
00614834
Message ID:
00614834
Views:
70
Hi,

I have developed a Billing System in VFP 6.0 which is installed in WIN'98 environment and network is Peer-to-Peer. The software is multiuser.

The table is BILL.DBF which have two candidate index on field BILLNO and DOCKETNO.

In the entry form, I have not included the table in DATAENVIRONMENT but open it with USE [table name] EXCLUSIVE command and after appending record I close it with USE command.

But I have observed that more than one record with same BILLNO ( index on BILLNO is candidate). I don't understand why this is happening. Please suggest me some solution - How to get rid of this problem.

Note: if I issue the reindex command, it generate an error of "INVALID DATABASE". Then I validate the database but after sometime it gives the same error.

Thanks
Aritra
Next
Reply
Map
View

Click here to load this message in the networking platform