I'm facing the pb I suppose :
Here is my models :
db.define_table("Poste",
Field("Poste", "string", notnull=False, default=None))
db.define_table("Article",
Field("CodeArticle","string", notnull=True, default=None),
Field("Designation","string", notnull=True, default=None))
db.define_table("GPGACLAR",
Field("CP_CLAR","string"),
Field("CP_CART","string"))
db.define_table("OF",
Field("META_OF", "integer",requires=IS_NOT_EMPTY()),
Field("META_RespOF","string"),
Field("META_Affectation", "string"),
Field("META_Debut", "datetime"),
Field("META_Fin", "datetime"),
Field("META_QTransfert", "integer"),
Field("META_Rques", "text"))
db.define_table("GPOF",
Field("OF_CODE", "integer",notnull=False, default=None),
Field("OF_CART", "string",notnull=False, default=None),
Field("OF_QUAN", "double",notnull=False, default=None))
db.define_table("LigneOF",
Field("OF", "integer"),
Field("Date","date", default=None),
Field("Equipe","integer", requires=IS_IN_SET(['1','2','3'])),
Field("Cdebut","integer", requires=IS_LENGTH(6)),
Field("Cfin","integer", requires=IS_LENGTH(6)),
Field("Qrebuts","integer", requires=IS_NOT_EMPTY()),
Field("Rques","text"))
db.OF.META_Affectation.requires=IS_IN_DB(db, 'Poste.Poste')
db.LigneOF.OF.requires=IS_IN_DB(db, 'GPOF.OF_CODE')
db.define_table("ATGAMME",
Field("GA_OUTI","string"),
Field("GA_CART","string"),
Field("GA_TSAI","double"))
db.define_table("NC",
Field("NC_Id", "integer"),
Field("NC_DOuverture", "date", default=now),
Field("NC_Num","string"),
Field("NC_Type",
requires=IS_IN_SET(["Interne","Client","Fournisseur"])),
Field("NC_Commande","string"),
Field("NC_Client","string"),
Field("NC_Rapport_Client","upload", autodelete=True),
Field('NC_Rapport_Client_filename'),
Field("NC_Four","string"),
Field("NC_Identifiant","string"),
Field("NC_Lot","string"),
Field("NC_Descripif","text"),
Field("NC_PotNC","string"),
Field("NC_QteeNC","string"),
Field("NC_DCloture","date"),
Field("NC_Image","string"),
Field("NC_Causes","text"),
Field("NC_Solutions","text"),
Field("NC_Moule","string"),
Field("NC_Derog","boolean"),
Field("NC_Rebuts","boolean"),
Field("NC_Rep","boolean"),
Field("NC_Reprise","text"),
Field("NC_Decideur","string"),
Field("NC_DesCout","text"),
Field("NC_Cout","integer"))
db.define_table("AC",
Field("AC_NC","integer",default=None),
Field("AC_Descriptif","text"),
Field("AC_Pilote","string"),
Field("AC_type",requires=IS_IN_SET(["Curative","Corrective","Préventive"])),
Field("AC_Delai","date"),
Field("AC_Realise","boolean"),
Field("AC_Verif","text"),
Field("AC_DVerif","date"),
Field("Ac_Cloturee","boolean"),
)
On 1.91.6 => SQLform submit Ok
On 1.92 => I can't submit my SQLForm is it related ti teh pb rãma
pointed ?
I downgraded to 1.91.6 and it works fin now ...
On 28 fév, 23:11, rāma <[email protected]> wrote:
> SQLFORM factory field name with underscore doesn't submit properly in
> the below case:
>
> SQLFORM.factory(Field('fieldname', ----- Submit OK
>
> SQLFORM.factory(Field('select_fieldname', ----- Submit failed got a
> None returned I think.
>
> just to add: form catches the session as well.
>
> Regards,
> Rama
