General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only