General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>PMFJI, but, updateable fields means that the field can have a different value in it then what it started with. You do not want the primary key to change - I hope. You just want the primary key to ID which record you are working with, correct?
Yes I do not want to update the primary key field. Primary key is only for relation to update. I made the primary key field only key field not updateable. For example I want to update the total points for customer who's ID is 7854. When i include customerid (primary key) field in view with key field mark only then I get update conflict error.
Is there any alternative way to update a specific record not all the table. If I remover the primary key field as key field it will update all the records in a table. I want to restrict the update to a specific record.
Previous
Next
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