Annet, sorry but I still do not have enough information to debug this. The table bedrijf for examples if missing. Moreover you are not telling me the steps to reduce the problem.
It would be great if could write write a smaller app that exhibits the problem or send me you complete app by email. Massimo On Jun 7, 1:34 am, annet <[email protected]> wrote: > Massimo, > > In db.py I have: > > db.define_table('adres', > db.Field('bedrijf',db.bedrijf,label='Bedrijf * > ',default='',notnull=True,ondelete='CASCADE'), > db.Field('adressoort',db.adressoort,label='Adressoort * > ',default='',notnull=True,ondelete='RESTRICT'), > db.Field('straat',label='Straat * > ',length=42,default='',notnull=True), > db.Field('huisnummer',label='Huisnummer * > ',length=6,default='',notnull=True), > db.Field('huisnummerextensie',length=6), > db.Field('postcode_cijferdeel',type='integer',label='Postcode > cijferdeel',), > db.Field('postcode_letterdeel',label='Postcode letterdeel'), > db.Field('plaats',label='Plaats * > ',length=42,default='',notnull=True), > db.Field('created_on',type='datetime'), > db.Field('modified_on',type='datetime'), > migrate=False) > > db.adres.bedrijf.requires=IS_IN_DB(db,db.bedrijf.id,'%(bedrijfsnaam) > s') > db.adres.adressoort.requires=IS_IN_DB(db,db.adressoort.id,'%(soort) > s',orderby=db.adressoort.id) > db.adres.straat.requires=[IS_LENGTH(42,error_message=T('length exceeds > 42')),IS_NOT_EMPTY()] > db.adres.huisnummer.requires=[IS_LENGTH(6,error_message=T('length > exceeds 6')),IS_NOT_EMPTY()] > db.adres.huisnummerextensie.requires=IS_LENGTH(6,error_message=T > ('length exceeds 6')) > db.adres.postcode_cijferdeel.requires=IS_NULL_OR(IS_MATCH('\d > {4}',error_message=T('no match 4 digits'))) > db.adres.postcode_cijferdeel.comment=SPAN('Format: > 1000/9999',_class='comment') > db.adres.postcode_letterdeel.requires=IS_NULL_OR(IS_MATCH('[A-Z] > {2}',error_message=T('no match 2 capitals'))) > db.adres.postcode_letterdeel.comment=SPAN('Format: AA/ > ZZ',_class='comment') > db.adres.plaats.requires=[IS_IN_DB(db,db.plaats.plaats,'%(plaats)s')] > db.adres.plaats.widget=lambda self,value:INPUT > (_type='text',_id='place',_class='ac_input',_name='plaats',value=str > (value),requires=self.requires) > db.adres.created_on.default=request.now > db.adres.created_on.readable=False > db.adres.created_on.writable=False > db.adres.modified_on.default=request.now > db.adres.modified_on.update=request.now > db.adres.modified_on.readable=False > db.adres.modified_on.writable=False > > .., in the controller the functions: > > @auth.requires_membership('core_manager') > def crud_address(): > response.functionname= T('CRUD adres') > response.flash=T('create new record') > response.flash_records= T('records in database') > response.flash_no_records= T('no records') > db.adres.bedrijf.writable=False > db.adres.bedrijf.default=auth.user.bedrijf > form=crud.create(db.adres) > form[0][-1][1].append(INPUT(_type='reset',_value='Reset')) > form[0][-1][1].append(INPUT > (_type='button',_value='Cancel',_onclick="window.location='%s';"%URL > (r=request,f='index'))) > records=db(db.adres.bedrijf==auth.user.bedrijf).select > (db.adres.ALL,orderby=db.adres.adressoort) > return dict(form=form,records=records) > > @auth.requires_membership('core_manager') > def update_address(): > response.view='core/update.html' > response.flash=T('update or delete record') > db.adres.bedrijf.writable=False > record=db.adres[request.args[0]] > if not record or not record.bedrijf==auth.user.bedrijf: > redirect(URL(r=request,f='crud_address')) > form=crud.update(db.adres,request.args[0],next=(URL > (r=request,f='crud_address'))) > form[0][-1][1].append(INPUT > (_type='button',_value='Cancel',_onclick='javascript:history.go > (-1)')) > return dict(form=form) > > ..., and two views the crud_address one and a generic on for > update_address: > > {{extend 'cmslayout.html'}} > > <div id="primarycolumn"> > <div id="primarycontent"> > <div class="flash"> > {{=response.flash}} > </div> <!-- flash --> > {{=form}} > <div id="dt_cms"> > {{if not records:}} > <div class="flash_records"> > {{=response.flash_no_records}} > </div> <!-- flash_records --> > {{else:}} > <div class="flash_records"> > {{=response.flash_records}} > </div> <!-- flash_records --> > <table id="cms" class="display"> > <thead> > <tr> > <th>straat</th> > <th>huisnummer</th> > <th>plaats</th> > <th>crud record</th> > </tr> > </thead> > <tbody> > {{for record in records:}} > <tr> > <td> > {{=record.straat}} > </td> > <td> > {{=record.huisnummer}} > {{=record.huisnummerextensie}} > <td> > {{=record.plaats}} > </td> > <td> > {{=A(T('update/delete'),_href=URL > (r=request,f='update_address',args=[record.id]))}} > </td> > </tr> > {{pass}} > </tbody> > </table> > {{pass}} > </div> <!-- dt_cms --> > </div> <!-- primarycontent --> > </div> <!-- primarycolumn --> > <div id="secondarycolumn"> > {{include 'cms_navigation.html'}} > </div> <!-- secondarycolumn --> > > <div id="primarycolumn"> > <div id="primarycontent"> > <div class="flash"> > {{=response.flash}} > </div> <!-- flash --> > {{=form}} > </div> <!-- primarycontent --> > </div> <!-- primarycolumn --> > <div id="secondarycolumn"> > {{include 'cms_navigation.html'}} > </div> <!-- secondarycolumn --> > > As I said, in version 1.61.4 this worked, I tested it again yesterday, > and it still does work , only in version 1.63.5 it breaks. > > Kind regards, > > Annet. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" 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 -~----------~----~----~----~------~----~------~--~---
