Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help - What am I doing wrong with this primary key
Message
From
05/12/2000 12:50:22
 
 
To
05/12/2000 12:43:18
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00449457
Message ID:
00449493
Views:
8
>>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform