You can't do it in data bound mode for SQL Server 2000.It gives an er

can we update a view which is created from two tables

Question Posted / chamin

Answer Posted / chamin

You can't do it in data bound mode for SQL Server 2000.It
gives an error called
"Insufficient key column information for updating or refreshing"

Is This Answer Correct ?

2 Yes

6 No

Please Help Members By Posting Answers For Below Questions

Which normal form is best?

948

List the ways to get the count of records in a table?

900

Should I use mbr or gpt?

1024

Why commit is not used in triggers?

1038

Is nosql relational?

941

How do you update a sql procedure?

1025

What is primary key and foreign key with example?

929

What are sql*plus environment variables?

1093

what is the difference between a web-garden and a web-farm? : Sql dba

1079

What is the maximum number of triggers, you can apply on a single table?

992

What are types of exception?

918

How to load data with sql*loader?

1046

Can you have more than one key in a database?

932

What is query optimization in sql?

983

How to rename a table?

1012