Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Repeate product codes
Message
From
01/08/2003 17:05:38
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00816019
Message ID:
00816044
Views:
24
>In a form I have the father table and mytable
> The the father table has a relation to mytable
>
> I have the fallowing code to add a new item to mytable
>
> use mytable
> go bottom
> Store mytable.cod to cod1
> cod2 = cod1 + 1
> append blank
> replace mytable.cod with cod2
>
>
> The problem is: Some times I have repeated cods
>
> It looks like it goes to the bottom
> depending to the relation and not to the real
> bottom of the table
> Anybody knows if this is possible to happen ?

USE the table AGAIN, without a relation, to avoid problems with the relation.

For a multiuser system, it may also help if you lock either the table header, or a record in another table which you create specifically for this purpose.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform