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