Re: [R] The RSQLite version of dbGetQuery drops colums

Hi Magnus, Magnus Torfason zulutime.net at gmail.com writes: I just noticed (the hard way of course) that when a query returns 0 rows, the columns in the resulting data.frame get dropped as well. See the following example code (where conn is an active connection to an SQLite db):

[R] The RSQLite version of dbGetQuery drops colums

Hi all, I just noticed (the hard way of course) that when a query returns 0 rows, the columns in the resulting data.frame get dropped as well. See the following example code (where conn is an active connection to an SQLite db): dbGetQuery(conn, select 1 as hey, 2 as ho where 1) hey ho 1