Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Primary Key
Message
De
06/06/2003 06:54:56
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00797053
Message ID:
00797102
Vues:
16
I mean backend wouldn't take but generate the id itself. If you'd generate then you'd decide to update it too or not.
Cetin


>Can't understand what you mean by ?
>
> surrogate IOW autogenerated ids.
>
>
>Aashish
>
>>Take ? I said surrogate IOW autogenerated ids.
>>Cetin
>>
>>>Well, primary key defined fields in Oracle dosent take empty or null values.
>>>
>>>Aashish
>>>
>>>>I believe in Oracle too you can generate surrogate primary keys.
>>>>Cetin
>>>>>I am mainly an Oracle guy. So it was tough for me to digest.
>>>>>
>>>>>Aashish
>>>>>
>>>>>>>Hi,
>>>>>>>
>>>>>>>Primary key accepts empty values. Should Primark Key behave like this ?
>>>>>>>Am I wrong somewhere ?
>>>>>>
>>>>>>If a primary key is accepting an empty value it's normal. It ensures value would be unique but doesn't guarantee it wouldn't be empty. ie: For an integer PK 0 is a perfectly legal value.
>>>>>>But if a primary key is accepting empty values then you've a problem. Keys might not be updating at all.
>>>>>>Not empty is something you should control as well as not null.
>>>>>>Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform