Code Comments
Programming Forum and web based access to our favorite programming groups.Hello, I'm posting here since I cannot find a proper list for FormBuilder. I have a big problem here: * I have a FB form with one linkNewValue linked table (PK on linked table points to FK on main table) * When there is an error in the main form, the linked new value in sub-form is inserted correctly in the DB, but the form is displayed again as nothing would happened in the sub form. * When I correct the main form and submit again, FB try to insert the sub-fo rm values again and fails because DB constraints check for uniq in the linked table. I don't know if this is a bug or I did'nt understand how it works. Expected behaviour: there are two possibilities: 1 - kind of rollback on insertion of linked sub-forms when the main form fai ls 2 - set the sub-form hidden PK to the value of the last inserted row and set the main form linked field to the same value Any help would be higly appreciated. TIA -- Alessandro Pasotti ICQ# 245871392 Linux User #167502
Post Follow-up to this messagePowered by vBulletin
Copyright 2000-2006 Jelsoft Enterprises Limited.