Kirk Haines wrote:
If, however, there is a way to get the name of the field from the API, then the driver could simply be patched to pass this info, like most of the drivers do, and then most of the time things should just work, without having to take extra steps.
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.
