Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Uniqueness error
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01242809
Message ID:
01242852
Vues:
18
>>1. Get rid of the empty record
>>
>>2. What do you use to provide this field uniqueness? NextID() idea?
>>This is a table for horses and the uniqueness field idea is because a horse can only have one parent.
>>
>>BTW, why do you need Numeric 10? Will Integer work for you?
>>because i need to related with the others tables with the same type of field.
>
>Change it, in both places. Integer data type requires 4 bites, N(10) - 10 bites. Of course in Integer you could store values from -2147483647 to 2147483647 but I think this is enough.

With only one parent needed to re-produce, perhaps it would not be enough for this new breed of horses :)
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform