On Tuesday, April 5, 2016 at 8:47:17 AM UTC-7, Vu Pham wrote: > > 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 ? >
Not at all true. <URL:http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Legacy-databases-and-keyed-tables> > Thanks for helping, > > /dps > 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.
