Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Question about views
Message
From
29/04/2006 22:43:21
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
29/04/2006 22:25:42
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
Miscellaneous
Thread ID:
01117697
Message ID:
01117862
Views:
22
>>>In MereMortals framework the PK are calculated in the view.
>>
>>Interesting. I assume that all data access is done through views, right?
>
>Hilmar, have you read my post?
>
>"No Problem, if you open the table directly, the User Defined Function call stored in the default value for the Primary key Field of the table is triggered. If you open table thru View, the same User Defined Function call will be made, this time from the View. Try it, I did."
>
>If you have the same UDF call as default value in the view and the table, you can use the view or the table directly, so its irrelevant if you just use always the view or sometimes the view and sometimes the table.
>
>Tal vez no me hago entender muy claramente en inglés, puede ser eso.
>
>Carlos

Wouldn't there be a conflict here? I would guess that the table first assigns one value through the primary key, and then the view assigns another, different, value. Or would the assignment in the view not allow the default value in the table to be invoked?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform