Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with Unique Ref Nos in Primary keys
Message
 
À
24/04/2001 22:22:19
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00499405
Message ID:
00499825
Vues:
15
Have you PACKed?

>I have been using fox since foxbase+, was very slow to get into VFP.
>
>I have recently had the dubious pleasure of taking over a project that has been written by several different programmers, over about 3years.
>
>The main bugbear is a fault "uniqueness of index is violated." Now, I have been to some trouble to adapt some already written code in the database procedures, so that before it releases a number ( integer), it does an indexseek on the underlying table, if found() then increments again, until not found().
>
>I think my problem is that the forms that call the procedure are using views, which I am not used to, and the fault still occurs, although I am (almost) certain that the procedure is working correctly.
>
>Any ideas? I am currently thinking of dumping all the views which are only direct copies of the originals. It taxes my brain too much!
>
>regards
>
>Alan
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform