On Tuesday, March 29, 2016 at 2:28:11 PM UTC-7, Ciro Alves wrote: > > Salve Pessoal > > Estou com um erro que não consigo resolver. Eu faço um select onde só > estão envolvidas variáveis inteiras mas, mesmo assim, recebo o erro acima > dizendo que uma variável float era requerida. > > Segue abaixo a descrição do erro. Não consigo passar do select. E o > estranho é que sempre funcionou. > > Alguma poderia sugerir onde está o problema? > > I think we're going to need to see where these tables are defined in your model. The error relates to a conversion between types, so perhaps you have a mismatch between *db.t_mpconsumida.f_ano_**referencia *and* ano_referencia, *or between *db.t_**mpconsumida.f_codigo_**materiaprima * and* db.t_materiaprima.f_codigo.*
/dps > Traceback (most recent call last): > File "C:\Users\Ciro\Documents\Profissionais\Web2py\Web2py > 2.13.4\gluon\restricted.py", line 227, in restricted > exec ccode in environment > File "C:/Users/Ciro/Documents/Profissionais/Web2py/Web2py > 2.13.4/applications/prods/controllers/default.py" > <http://127.0.0.1:8000/admin/default/edit/prods/controllers/default.py>, line > 268, in <module> > File "C:\Users\Ciro\Documents\Profissionais\Web2py\Web2py > 2.13.4\gluon\globals.py", line 412, in <lambda> > self._caller = lambda f: f() > File "C:/Users/Ciro/Documents/Profissionais/Web2py/Web2py > 2.13.4/applications/prods/controllers/default.py" > <http://127.0.0.1:8000/admin/default/edit/prods/controllers/default.py>, line > 265, in list_mp > > *recs = db((db.t_mpconsumida.f_ano_referencia == > ano_referencia)&(db.t_mpconsumida.f_codigo_materiaprima == > db.t_materiaprima.f_codigo)).select(orderby=db.t_produto.f_prodlist) *File > "C:\Users\Ciro\Documents\Profissionais\Web2py\Web2py > 2.13.4\gluon\packages\dal\pydal\objects.py", line 2025, in select > return adapter.select(self.query,fields,attributes) > File "C:\Users\Ciro\Documents\Profissionais\Web2py\Web2py > 2.13.4\gluon\packages\dal\pydal\adapters\sqlite.py", line 124, in select > return super(SQLiteAdapter, self).select(query, fields, attributes) > File "C:\Users\Ciro\Documents\Profissionais\Web2py\Web2py > 2.13.4\gluon\packages\dal\pydal\adapters\base.py", line 1293, in select > return self._select_aux(sql,fields,attributes) > File "C:\Users\Ciro\Documents\Profissionais\Web2py\Web2py > 2.13.4\gluon\packages\dal\pydal\adapters\base.py", line 1274, in _select_aux > return processor(rows,fields,self._colnames,cacheable=cacheable) > File "C:\Users\Ciro\Documents\Profissionais\Web2py\Web2py > 2.13.4\gluon\packages\dal\pydal\adapters\base.py", line 1764, in parse > for row in rows] > File "C:\Users\Ciro\Documents\Profissionais\Web2py\Web2py > 2.13.4\gluon\packages\dal\pydal\adapters\base.py", line 1674, in _parse > value = self.parse_value(value, ft, blob_decode) > File "C:\Users\Ciro\Documents\Profissionais\Web2py\Web2py > 2.13.4\gluon\packages\dal\pydal\adapters\base.py", line 1524, in parse_value > return self.parsemap[key](value,field_type) > File "C:\Users\Ciro\Documents\Profissionais\Web2py\Web2py > 2.13.4\gluon\packages\dal\pydal\adapters\base.py", line 1601, in parse_decimal > value = ('%.' + str(decimals) + 'f') % value > TypeError: float argument required, not str > > -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
