Update Record: A very peculiar behavior: Specify value for at least one column?? Submit at least one column as primary key??
Posted on 2004-07-30
I just don't get this update record behavior.
First, I used the "insert master detal set" to make two pages. I initially did this showing only ID, name and description fields in the master page, and all table fields in the detail page for a given item.
Then I (somehow, don't ask) added an update record behavior to this detail page. Unfortunately, the detail page only showed the record fields that showed in the detail page were the ID, name and description, and when I updated one description, the record data in all the other fields (except the ID and name) was overwritten in the database as blank.
This was no good, so I redid the master detail set from scratch, summoning all the fields for all the records in the database in the master page, and all the fields in the detail page for the selected record detail.
Now, Dreamweaver (MX 2004) will not allow me to put in the update record behavior. In the update record dialog, I am shown all the fields in the table with a message that "The field does not get a value." And in the value area below, there is no option of giving any value to any field. So whwn I go to "okay," I get two error messages: "Please specify a value for at least one of the columns." and "Please submit at least one column as primary key."
Now, these seem like reasonable requests, but for the life of me I cannot find a way of getting DW to oblige.
Ideally, I'd like a rock solid, idiot proof, bulleted "how to" list for making an update page.