search for: time__1

Dear All, Is sqldf equipped with delete queries? I have tried delete queries but with no success. Thanks in advance, Paul

...new version of DBI package, DBI 0.2-5. The default action of this version of DBI quotes those column names in select statements that are SQL reserved words (rather than appending __1 to them which was the previous default action). As a result it should no longer be necessary to refer to Time as Time__1, etc. Thus this now works where BOD is a 6 row data frame that comes with R and has the indicated column names: sqldf("select Time, demand from BOD") - if the libspatialite-1.dll sqlite loadable extension is found on PATH then it will automatically be loaded into SQLite the first t...

...new version of DBI package, DBI 0.2-5. The default action of this version of DBI quotes those column names in select statements that are SQL reserved words (rather than appending __1 to them which was the previous default action). As a result it should no longer be necessary to refer to Time as Time__1, etc. Thus this now works where BOD is a 6 row data frame that comes with R and has the indicated column names: sqldf("select Time, demand from BOD") - if the libspatialite-1.dll sqlite loadable extension is found on PATH then it will automatically be loaded into SQLite the first t...