I have duplicated the problem with a very simple test db. I have two tables, PARENT & CHILDREN. There is a one to many relationship From PARENT to CHILDREN. Using the CF wizard I generated a Master list of parents, and a Detail form. The Detail form allows users to enter parent information and has a datagrid subform where users can enter children of the parent. On new forms, the generated code fails to insert children into the db. On subsequent edits of the parent, children information is successfully updated into the db. Seems like because the PARENT primary key (foriegn key in CHILDREN) is auto-created by SQL, it is not available for CHILDREN insert operations and so fails. On edits, the key exists and updates are successful. however, this is a fairly common way of generating primary keys and should be handled by the wizard. Again anyone have any ideas?
Dan --- In [email protected], "nall_daniel" <[EMAIL PROTECTED]> wrote: > > My sub-form in a CF Wizard generated form is not inserted into the > database. I have a purchase form with a main form and a subform > (datagrid). Main form is based on a table and subform on a related > table. The form was generated by using the CF Wizard in Flex Builder. > For a new purchase, the create (SQL INSERT) operation will insert the > main form data into the database but does not insert the subform data. > It does not fail or error out. It simply doesn't insert the data. If > I then edit the same purchase, the update (SQL UPDATE) function works > perfectly and all data is passed. The are no flash debug errors nor > SQL errors. > > Any ideas? > > Dan >
