VN
|
| Posted: 04/07/2005, 3:55 AM |
|
Hello
I have two pages with an editable grid on each. One the first page, the grid works just fine. I can add and/or edit and/or delete any of the records and it works as intended. (all the fields in the database used for this grid are defined as not null).
One the second page, I can add records but when I try to modify existing records in the grid, it seems to always want to add a new record and brings up a message saying that are required (presumable because they are defined as not null in the database) and the update fails.
The only difference is that the second table has an auto-increment primary key (it's a mysql database).
Are there any special requirements for making an editable grid work properly with auto-increment PKs?
Voya
|
|
|
 |
Nicole
Posts: 586
|
| Posted: 04/07/2005, 6:12 AM |
|
Voya,
Most probably you assigned default value to on of editable controls on editable grid form. You’d rather use Before Build Insert and Before Build Update events to assign default value to input type controls (Hidden, TextBoxes, ListBoxes, etc.). In this case the field that is submitted to the table get the value but if no record should be inserted the input controls located in the blank grid record’s will be blank and thus no additional records are inserted.
This is feature of Editable Grid
_________________
Regards,
Nicole |
 |
|
E43509
Posts: 283
|
| Posted: 04/07/2005, 6:17 AM |
|
Or you may have a checkbox. That will make CCS believe that something is in that row. Change any checkbox to list boxes
|
|
|
|
|
