On Tue, 05 Oct 2004 12:16:15 -0700, Will Leshner <[EMAIL PROTECTED]> wrote: > Kirk Haines wrote: >
> You can use #PRAGMA table_info() to find out information about the columns in a > table, including which columns are primary keys. But you can have more than one > primary key column and they don't have to be INTEGER columns. You'll have to do a > bit more work to figure out which column maps to the 'rowid' column, I think. Thanks. More than one field as a primary key is not a problem. The ORM package handles that, and it doesn't matter whether they are integers for the ORM package, either. It just needs to be able to reasonable guess at the developer's intentions from the table design. Thanks again, Kirk Haines
