FormBuilder linkNewValue issue

From: Date: Thu, 19 May 2005 07:10:39 +0000
Subject: FormBuilder linkNewValue issue
Groups: php.db 
Request: Send a blank email to php-db+get-39500@lists.php.net to get a copy of this message
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-form 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 fails 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

« previous php.db (#39500) next »