Re: FormBuilder problem with links

> > 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) > > ); > > Perhaps you need to capitalize the table names in the links.ini? no, the autogen script itself do a "lowercase" in the database.ini file, so it seemed not to be case sensitive. But i know my source problem : i must set "null" to my foreign keys columns (see the other post with the same objet, i dont know why but my message is posted twice).