Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Help - What am I doing wrong with this primary key
Message
De
05/12/2000 12:50:22
 
 
À
05/12/2000 12:43:18
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00449457
Message ID:
00449493
Vues:
13
>>>Thanks Trey
>
>>
>>Yep. You can set it with DBSETPROP(), unlike the default for a table field. e.g.,
>>DBSetProp("v_ticket.p_ticket", "Field", "Default", "NextKey()")
>
>But I can not see how it would help me since my Nextkey routine will return a different value if it is called twice.
>
>And since my Nextkey routine just uses a replace anyway I would expect to still be in the same boat.

It won't get called twice. Since the p_ticket field in the inserted record in the view already has a value, the default of the p_ticket in the table won't fire when the view is updated.
If you don't believe me, try it and see :)
Insanity: Doing the same thing over and over and expecting different results.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform