General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi John,
Thanks for your quick response.
The view is based on 2 tables. One of these tables must be updated. I generate the key by calling a stored procedure from whithin the defaultvalue of the Pk in the view. When I browse the view all inserted records have correct keys.
The PK field (of the table which must be updated) is marked as keyfield and marked as updatable.
Maybe this gives you any clue. According to the help when I click on the Reset Key button, all PK fields must be marked automaticaly. In my case no fields are marked. (Both tables have a primary index.)
Marco
>Hi Marco,
>
>Could be several things. Most likely, is the primary key field marked as a keyfield? Secondly, how are you generating your primary keys? You have to ensure that they are unique. Finally, is the key field updatable? The default in the View Designer is no, and it's a common error to not check it off.
>
>
>
>>
>>I have a problem using a updatable view. I insert several records to the view. I generate the primary key in the view. The view is tablebufferd. After a TableUpdate only one record is added to the source-tabel. This record has Id 0.
>>
>>I can't figure out why this is going wrong. Does anybody has a suggestion.
>>
>>(The source-table is not opened in the data-environment)
>>
>>Marco
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only