Re: Problem with FormBuilder links

After having marking foreign keys "null" for "ATTRIBUT_L_PARAM" table, it works fine. Thanks. "Norbert Mocsnik" <pear-general@mocsnik.hu> a écrit dans le message news: 407BBE0A.9090700@mocsnik.hu... > Hello Lilian, > > There's still a bug in FormBuilder. Try to mark all linked integer fields with "not null" or "null" in your database and see what happends. Probably "null" will work and "not null" won't. > > Regards, > Norbert > > Lilian BRUN wrote: > > > I don't know why but when i use this, sometimes the "magic select menu" > > function works, and sometimes not. > > (i've downladed the CVS last version) > > > > I've not seen in the documentation what are all prerequies between mys > > database.links.ini file and the database itself to let the Formbuilder > > autogenerate the select box. (i actually use the proposed Frontend tool to > > validate my settings) > > > > In my example, the administration of the "descriptor_value_date" works fine, > > with 3 select box, > > but for the "attribut_l_param" table, i've got no select box, even if in the > > "Frontend" application, it displays "attribut" and > > "parametre" as linked > > tables. > > > > So what are prerequies, or were's my mistake ? > > > > > > Thanks for your help. > > > > > > here's my example scripts : > > > > dataObject.ini : > > [DB_DataObject_FormBuilder] > > follow_links = 2 > > select_display_field = LIBELLE > > select_order_field = ID > > > > > > database.links.ini : > > [parametre] > > ID_TYPE_PARAM = type_parametre:ID > > ID_EST_GENERIQUE = booleen:ID > > > > [attribut_l_param] > > ID_ATTRIBUT = attribut:ID > > ID_PARAM = parametre:ID > > > > [attribut] > > ID_ATTRIBUT_PERE = attribut:ID > > > > [descriptor_value_date] > > ID_OBJET = objet:ID > > ID_ATTRIBUT = attribut:ID > > ID_PARAM = parametre:ID > > > > > > > > Create table script : > > > > create table DESCRIPTOR_VALUE_DATE > > ( > > ID int not null, > > ID_OBJET int, > > ID_ATTRIBUT int, > > ID_PARAM int, > > META_DATA date, > > primary key (ID) > > ); > > > > create table ATTRIBUT > > ( > > ID int not null, > > ID_ATTRIBUT_PERE int, > > CODE char(30), > > LIBELLE char(255), > > DESCRIPTION tinytext, > > primary key (ID) > > ); > > > > create table PARAMETRE > > ( > > ID int not null, > > ID_TYPE_PARAM int, > > CODE char(30), > > LIBELLE char(255), > > DESCRIPTION tinytext, > > ID_EST_GENERIQUE int, > > primary key (ID) > > ); > > > > create table ATTRIBUT_L_PARAM > > ( > > ID int not null, > > ID_ATTRIBUT int not null, > > ID_PARAM int not null, > > primary key (ID) > > ); > >