On 18 Oct 2009, at 8:37am, Ron Arts wrote: > Is there a way to bypass the virtual machine altogether and reach > directly > into the btree and just retrieve one record by it's oid (primary > integer key), > and return it in a form that would allow taking out the column > values by name?
The primary integer key column can always be referred to as the special name ROWID, even if you have assigned it a column name of your own. So you can do SELECT ROWID,myCol1,myCol2 FROM myTable as long as you don't explicitly declare a primary integer key column and then change the values in it. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
