Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with Unique Ref Nos in Primary keys
Message
 
To
24/04/2001 22:22:19
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00499405
Message ID:
00499825
Views:
16
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
Previous
Reply
Map
View

Click here to load this message in the networking platform