Thank you for your information.
One more question:
I have no problem to use this SQL statement db.executesql(select ....) with
the same table name below.
but not db(db.tablename).select(...).
The system complains that the tablename is not defined.
Is it true that any table created outside of DAL can not be used in any DAL
statement ?
Thanks for helping,
On Monday, April 4, 2016 at 7:22:46 PM UTC-7, Brian M wrote:
>
> I think db._tables only lists the tables you have defined within the DAL
> rather than going to the database itself and listing any tables that are
> there independent of the DAL (for example if you are connecting to a
> database that wasn't created through the DAL). Have you defined any tables
> within the DAL yet? Or if you already have tables in an existing database
> you could use db.executesql("select * from some_table_in_database") and see
> if you get anything back.
>
> Sample code might be helpful if you think something isn't working
>
--
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.
