> "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.