number is not unique, can it even be used as a PK? -Thadeus
On Mon, Dec 7, 2009 at 3:35 PM, Tim Michelsen <timmichel...@gmx-topmail.de> wrote: >> "Support for legacy tables" can have two meanings: >> >> 1) Legacy tables that need an alias for the id field. >> sqlite supports this case. > > >> 2) Legacy tables that use primary keys (not an id field) to get the >> records. >> sqlite does not support this AFAIK. > > > What I have is a CSV file. > The data is from: > http://www.ncdc.noaa.gov/oa/climate/rcsg/cdrom/ismcs/alphanum.html > > I converted this into a SQLITE file with sqlite-browser. > > How can I make web2py connect to that data base? > Normall, web2py would require to generate its ID field. > But I would rather use the "Number" column as id / identifier. > > Could you please give me some hints? > > Thanks in advance, > Timmie > > -- > > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@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. > > > -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@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.
