On Wednesday, June 1, 2016 at 12:38:41 PM UTC-7, Sammy wrote:
>
> I am still missing something.
>
> I now have this in model
>
> my_db = DAL('oracle://username/password@Database', migrate_enabled=False)
> my_db.define_table('Table1', Field('field1'),
> Field('field2'),
> Field('Field3'),
> )
>
> # The above does not includes all the fields available in the real Table,
> just a subset,but with real field names
>
> My controller has this
>
> def display_form():
> myquery = (my_db.Table1.field1 == 'Apple')
> myset = my_db(myquery)
> rows = myset.select()
> return locals()
>
> And my view is simply
>
> {{=rows}}
>
>
> When I click on the link, I get this error:
> <class 'cx_Oracle.DatabaseError'> ORA-00942: table or view does not exist
>
>
>
> I was expecting to get query result matching Field1 = apple by querying
> the real Oracle DB.
>
> What am I doing wrong?
>
>
Do yu need to use the fake_migrate=True option? See
<URL:http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Migrations>
/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.
