Re: Problem with FormBuilder links

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) );