Sorry my bad, it is "reference ni" not references
db.define_table("ni",
SQLField("ni_componente_01", "reference ni"))
-Thadeus
On Mon, Sep 14, 2009 at 12:32 PM, ProfessionalIT <[email protected]>wrote:
>
> I'm tryng this:
>
> db.define_table('ni',
> SQLField('cliente',db.clientes),
> SQLField('desenho',db.desenhos),
> SQLField('descricao','text'),
> SQLField('componente','string', length=03, default='Não'),
> SQLField('origem_materia_prima','string', length=10,
> default='Cliente'),
> SQLField('ni_componente_01','references ni'),
> SQLField('ni_componente_02','references ni'),
> SQLField('ni_componente_03','references ni'),
> SQLField('ni_componente_04','references ni'),
> SQLField('ni_componente_05','references ni'),
> SQLField('ni_componente_06','references ni'))
> db.ni.cliente.requires=IS_IN_DB(db, 'clientes.id',
> 'clientes.razao_social')
> db.ni.desenho.requires=IS_IN_DB(db, 'desenhos.id', 'desenhos.codigo')
> db.ni.descricao.requires=IS_NOT_EMPTY()
> db.ni.componente.requires=IS_IN_SET(['Sim', 'Não'])
> db.ni.origem_materia_prima.requires=IS_IN_SET(['Cliente', 'Comprada'])
> db.ni.ni_componente_01.requires=IS_NULL_OR(IS_IN_DB(db, 'ni.id',
> 'ni.id'))
> db.ni.ni_componente_02.requires=IS_NULL_OR(IS_IN_DB(db, 'ni.id',
> 'ni.id'))
> db.ni.ni_componente_03.requires=IS_NULL_OR(IS_IN_DB(db, 'ni.id',
> 'ni.id'))
> db.ni.ni_componente_04.requires=IS_NULL_OR(IS_IN_DB(db, 'ni.id',
> 'ni.id'))
> db.ni.ni_componente_05.requires=IS_NULL_OR(IS_IN_DB(db, 'ni.id',
> 'ni.id'))
> db.ni.ni_componente_06.requires=IS_NULL_OR(IS_IN_DB(db, 'ni.id',
> 'ni.id'))
>
> And I receive this error message:
>
> SyntaxError: Field: unknown field type: references ni for
> ni_componente_01
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
