Hmm... Is "table_name" what you exactly use in your code or does it stand for a table name that you actually keep from us to know (it ok we don't know the name of your entity if you want ot keep it secret)? Because I thinking that you use litterally 'table_name' in your code and that would be amuzing if you actually have called one of your database table table_name... Anyway, if you have not defined a table "table_name" in you models, you need one (better use a better name though).
DAL seems to complaint about you try to access a none existing table/entity... Richard On Wed, Jun 15, 2016 at 9:00 PM, Joe <[email protected]> wrote: > Hi Dave, > > Thanks for your reply. > > I am using the SQLITE on localhost offline on my PC. Basically, I have all > the web2py default settings in my app. > > I just created a grid to check if I can view the records that way. The > records are displayed in the grid but when I click view to select a row in > the grid I get the same error I get when I try to view the row records in > the database admin. > > I have several other apps with the same controller code and same table > structure and they work fine. The only difference is that in this app, in > the tables I didn't use : > > requires=[IS_NOT_EMPTY(),* IS_NOT_IN_DB(db, 'table_name')]*) > > I just used: > > requires=IS_NOT_EMPTY()) > > I don't think that could cause this error... > > Cheers, > > Joe > > > On Thursday, June 16, 2016 at 7:26:03 AM UTC+8, Dave S wrote: >> >> >> On Wednesday, June 15, 2016 at 3:41:21 PM UTC-7, Joe wrote: >>> >>> [...] >>> >> >> >>> To be more clear, in the database administration, in db.table_name, in >>> column db.table_name.id, when I click to select a row by ID I get this >>> error. >>> >>>> >>>> >> You have multiple rows shown in the admin display, I take it. >> >> What is the backend you're using for your database? Can you select rows >> when you're in the db tool for that backend (a console app, or such; if >> you're using SQLITE, it's the sqlite3 shell). >> >> /dps >> >> -- > 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. > -- 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.
