Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Uniqueness error
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01242809
Message ID:
01242852
Views:
17
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform