On Sep 7, 4:53 pm, Tim Michelsen <timmichel...@gmx-topmail.de> wrote:
> Hello,
> I have troubles connecting and using an existing SQLite table from web2py.
>
> Here are my steps and difficulties
>
> 1) imported an existing table into sqlite
> 2) table definition with migrate=False
> => I get no values/entries shown in the database administration!
>
> If I set migrate=True I get an error ticket telling that the table exists.
>
> "OperationalError: table mydata already exists"
>
> Why does this happen?
>
> How can I connect to an existing sqlite table?

yes but migrate=False

> Do I need to create a ID column before?

yes

> Can I  define another table field as id?

no

Hope this helps.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to