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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
