[web2py] Re: Computed field

2011-12-22 Thread Jose Carlos Junior
Sorry it worked.i made a mistake Thank you Jim On 22 Dez, 09:46, Jose Carlos Junior wrote: > Dont workedthe field dont show in form > > Sorry...any ideas ?? > > On 21 Dez, 22:05, Jose Carlos Junior wrote: > > > > > > > > >  Than

[web2py] Re: Computed field

2011-12-22 Thread Jose Carlos Junior
Dont workedthe field dont show in form Sorry...any ideas ?? On 21 Dez, 22:05, Jose Carlos Junior wrote: >  Thank you Jim .i gonna try this as soon as possibleand > return... > > On 21 dez, 18:21, Jim Steil wrote: > > > > > > > > &g

[web2py] Re: Computed field

2011-12-21 Thread Jose Carlos Junior
27;) > > This is untested.  I haven't used compute fields based on a math > function before, but like I said, this is what I'd try first. > > Hope this helps. > >      -Jim > > On 12/21/2011 1:43 PM, Jose Carlos Junior wrote: > > > > > > >

[web2py] Computed field

2011-12-21 Thread Jose Carlos Junior
People, How can I make the field NR_INDISPONIBILIDADE the table below (chamado) in a computed field with the difference between the field dates DT_FECHAMENTO and DT_ABERTURA. Thank you, db.define_table("chamados" ,Field('ID_CHAMADOS',type='id',readable=False) ,Field('ID_TECNICO

[web2py] Re: computed field or is_in_db(query...

2011-12-20 Thread Jose Carlos Junior
Solved..Thanks alot... dear Richard Vézina On 19 dez, 21:42, Jose Carlos Junior wrote: > Good idea... > >    I gonna try thisas soon as possible > Thanks alot... > > On 19 dez, 17:44, Richard Vézina wrote: > > > > > > > > > Carlos, > &g

[web2py] Re: computed field or is_in_db(query...

2011-12-19 Thread Jose Carlos Junior
Mon, Dec 19, 2011 at 11:54 AM, Richard Vézina < > > > > > > > > ml.richard.vez...@gmail.com> wrote: > > What about that : > > > db.tab2(db.tab1(id).id).field > > > ?? > > > Richard > > > On Mon, Dec 19, 2011 at 11:42 AM, Jo

[web2py] Re: computed field or is_in_db(query...

2011-12-19 Thread Jose Carlos Junior
OK but i need to call from gtils_representante table the nm_cidadao from cidadao tablethis is my doubt gtils_representante is a n:n relationship between GTIL(not posted) and representante. I believe I have not explained it right the first time...

[web2py] computed field or is_in_db(query...

2011-12-19 Thread Jose Carlos Junior
Please...I have some dificult in do this in web2py...as follow db.define_table("cidadao" ,Field('CD_CIDADAO',type='id', label='Cidadão(PK)') ,Field('CD_MATRICULA',type='integer',notnull=True,label='Matrícula') ,Field('NM_CIDADAO',type='string',notnull=True,label='Nome') ,format =

[web2py] Help

2011-12-19 Thread Jose Carlos Junior
Please...I have some dificult in do this in web2py...as follow db.define_table("cidadao" ,Field('CD_CIDADAO',type='id',label='Cidadão(PK)') ,Field('CD_MATRICULA',type='integer',notnull=True,label='Matrícula') ,Field('NM_CIDADAO',type='string',notnull=True,label='Nome') ,format = '