Do you have a
dbib.define_table('Convenios',...,migrate=True or False)
without this, web2py does not know that the table exists.
On Oct 8, 11:22 am, José Luna Venezuela <[email protected]> wrote:
> i'm having problems with this funtión
> rows=dbib().select(dbib.Convenios.ALL)
>
> Data base def
>
> import pyodbc
> dbib=DAL('mssql://user:passw...@databaseserver/database?
> DRIVER={FreeTDS}')
>
> in controller:
>
> def convenios():
> rows=dbib().select(dbib.Convenios.ALL) # if I use this it dosen't
> works...
> #rows=dbib.executesql('SELECT * FROM Convenios;') # if I use this
> it works...
> return dict(Datos=rows)
>
> Error detail:
>
> Error traceback
> Traceback (most recent call last):
>
> File "/home/administrador/web2py/gluon/restricted.py", line 188, in
> restricted
>
> exec ccode in environment
>
> File "/home/administrador/web2py/applications/init/controllers/
> default.py", line 68, in <module>
>
> File "/home/administrador/web2py/gluon/globals.py", line 96, in
> <lambda>
>
> self._caller = lambda f: f()
>
> File "/home/administrador/web2py/applications/init/controllers/
> default.py", line 65, in convenios
>
> rows=dbib().select(dbib.Convenios.ALL)
>
> File "/home/administrador/web2py/gluon/sql.py", line 1380, in
> __getattr__
>
> return dict.__getitem__(self,key)
>
> KeyError: 'Convenios'
