Re: FormBuilder problem with links

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

Perhaps you need to capitalize the table names in the links.ini? -- paperCrane <Justin Patrin>