Do you mean the records are being inserted/updated without those template 
values?

Can you attach a minimal app that reproduces the problem?

Anthony

On Monday, December 21, 2015 at 7:24:04 AM UTC-5, Karl Florian wrote:
>
> *Hi,*
> *I too upgraded to this Version.*
>
> *My issue is the following controller function worked in the previous 
> versions but not in this one.*
>
> *The onvalidation def txtlabel_valupd(form): is not filling my 
> form.vars.titel and form.vars.posting *
> *as it did in previous versions!?*
>
> *If form.vars.title is empty the function should get the title and posting 
> out of the text-template db*
> *and fill them into the form fields. But it doesn't.*
> *Is there anything wrong with the coding?* 
> *Or is there a better way of moving the field values out of the 
> texttemplate (alltext) table*
> *into the textlabel (altxtlbl) table ?*
>
>
> *This is my code and table definitions:*
>
> *def txtlabel_edit():*
>     def txtlabel_valupd(form):
>         if len(form.vars.text_mc) >0 and len(form.vars.titel)<=0:
>             
> alltxtrec=db(db.alltext.text_mc==form.vars.text_mc).select().first()
>             if alltxtrec:
>                 form.vars.titel=alltxtrec.titel
>                 form.vars.posting=alltxtrec.posting
>
>     def txtlabel_valnew(form):
>         if len(form.vars.text_mc) >0 and len(form.vars.titel)<=0:
>             alltxtrecs=db(db.alltext.text_mc==form.vars.text_mc).select()
>             if alltxtrecs[0]:
>                 form.vars.titel=alltxtrecs[0].titel
>                 form.vars.posting=alltxtrecs[0].posting
>
>     db.altxtlbl.text_mc.requires = 
> IS_EMPTY_OR(IS_IN_DB(db,db.alltext.text_mc,'alltext.description'))
>     if len(request.args):
>         session.recstat = 'upd'
>         req_id=request.args(0)
>         record = db.altxtlbl(request.args(0))
>         btn_list = [TAG.button(SPAN(_class="icon-arrow-left glyphicon 
> glyphicon-arrow-left"),' Back',_type='button', _onClick = 
> "parent.location='%s' " % 
> URL('txtlabel_grid')),TAG.button(SPAN(_class="icon-ok glyphicon 
> glyphicon-ok"),' Submit', _type='submit', _id='submit_btn'), 
> TAG.button(SPAN(_class="icon-refresh glyphicon glyphicon-refresh"),' 
> Reset', _type='reset', _onclick='return confirm("Are you sure you want to 
> reset the form?");', _id='clear_btn'),TAG.button(SPAN(_class="icon-pencil 
> glyphicon glyphicon-pencil"),' New-Label',_type='button',_onClick = 
> "parent.location='%s' " % URL('orders', 'txtlabel_edit', 
> args=[])),TAG.button(SPAN(_class="icon-print glyphicon glyphicon-print"),' 
> Txt-Label',_type='button',_onClick = "parent.location='%s' " % 
> URL('print_txtlabel', args=req_id))]
>         db.altxtlbl.posting.requires =  requires=IS_LENGTH(1000,30)
>         
>         form = SQLFORM(db.altxtlbl, 
>                         record,
>                         buttons = btn_list,
>                         formstyle = 'table3cols',
>                         user_signature=True)
>         form.process(onvalidation=txtlabel_valupd, 
> session=settings.editsession) 
>         if form.accepted:
>             response.flash = 'record saved'
>             redirect(URL('txtlabel_edit', args=form.vars.id))
>         elif form.errors:
>             response.flash = 'form has errors'
>     else:
>
> db.define_table(
>     'alltext',
>     Field('text_mc', 'string', length=8, unique=True, label='Text-MC'),
>     Field('description', 'string', length=50, requires=IS_NOT_EMPTY(), 
> label='Description'),
>     Field('titel', 'string', length=50, requires=IS_NOT_EMPTY(), 
> label='Titel'),
>     Field('posting', 'text', length=1000, requires=IS_LENGTH(1000,30), 
> label='Text'),
>     Field('date_changed', 'datetime', update = request.now, writable = 
> False, label=T('Modified')),
>     Field('user_id', 'reference auth_user', update=auth.user and 
> auth.user.id, writable = False, readable = False),
>     migrate=settings.migrapp,
>     redefine=settings.redefin,
>     format='%(text_mc)s'
> )
> db.alltext.text_mc.requires = [IS_NOT_IN_DB(db, 'alltext.text_mc'), 
> IS_UPPER(), IS_LENGTH(minsize=2, maxsize=8)]
>
> db.define_table(
>     'altxtlbl',
>     Field('order_date', 'datetime', default = request.now, 
> label='Order-Date'),
>     Field('text_mc', 'string', length=8, label='Text-MC'),
>     Field('titel', 'string', length=50, label='Titel'),
>     Field('posting', 'text', length=1000, label='Text'),
>     Field('no_label', 'integer', notnull=True, requires = 
> IS_INT_IN_RANGE(1, 10000), label='No-of-Label'),
>     Field('client_mc', 'string', length=8, requires = 
> IS_IN_DB(db,db.alcustomers.cust_mc,'alcustomers.name1'), label='Client-MC'),
>     Field('orderdatemc', 'string', length=25, compute=lambda r: '%s%s' % 
> (r.text_mc,r.order_date), label='Order-MC-Date'),
>     Field('date_printed', 'datetime', writable = False, 
> label='Date-Printed'),
>     Field('date_created', 'datetime', default = request.now, writable = 
> False, label='Created'),
>     Field('date_changed', 'datetime', update = request.now, writable = 
> False, label='Modified'),
>     Field('user_id', 'reference auth_user', update=auth.user and 
> auth.user.id, writable = False, readable = False),
>     migrate=settings.migrapp,
>     redefine=settings.redefin,
>     format='%(order_date)s %(text_mc)s'
> )
> db.altxtlbl.orderdatemc.requires = [IS_NOT_IN_DB(db, 
> 'altxtlbl.orderdatemc')]
> db.altxtlbl.titel.requires = requires=IS_LENGTH(50,0)
>
>
>  
>
> Am Freitag, 18. Dezember 2015 07:31:38 UTC+1 schrieb Massimo Di Pierro:
>
>> CHANGELOG
>>
>> ## 2.13.1
>>
>>
>> - fixed oauth2 renew token, thanks dokime7
>>
>> - fixed add_membership, del_membership, add_membership IntegrityError 
>> (when auth.enable_record_versioning)
>>
>> - allow passing unicode to template render
>>
>> - allow IS_NOT_IN_DB to work with custom primarykey, thanks timmyborg
>>
>> - allow HttpOnly cookies
>>
>> - added fabfile.py
>>
>> - french pluralizaiton rules, thanks Mathieu Clabaut
>>
>> - fixed bug in redirect to cas service, thanks Fernando González
>>
>> - allow deploying to pythonanywhere from the web2py admin that you're 
>> running locally, thanks Leonel
>>
>> - better tests
>>
>> - many more bug fixes
>>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to