Sqldf - error message - Mailing list pgsql-sql

<p><font face="Arial" size="2">Hi All!</font><p><font face="Arial" size="2">I just discovered sqldf and im very
enthousiastic,as I am a big fan of R and I often get frustrated using Access for datamanagement.</font><p><font
face="Arial"size="2">I tried running some queries from Access in R, and it works very well. However, I have problems
withsome queries.</font><p><font face="Arial" size="2">If I run this SQL query:</font><p><font face="Arial"
size="2">>sqldf("SELECT</font><br /><font face="Arial" size="2">+ dbo_tbl_Terrein.RingCentraleNaam,</font><br
/><fontface="Arial" size="2">+ dbo_tbl_Broedsels.BroedselID</font><br /><font face="Arial" size="2">+ FROM
((dbo_tbl_BroedselLocatie</font><br/><font face="Arial" size="2">+ INNER JOIN dbo_tbl_Broedsels ON
dbo_tbl_BroedselLocatie.BroedselID= dbo_tbl_Broedsels.BroedselID)</font><br /><font face="Arial" size="2">+ INNER JOIN
dbo_tbl_NestkastenON dbo_tbl_BroedselLocatie.NestkastID = dbo_tbl_Nestkasten.NestkastID)</font><br /><font face="Arial"
size="2">+INNER JOIN dbo_tbl_Terrein ON dbo_tbl_Nestkasten.TerreinNummer = dbo_tbl_Terrein.TerreinNummer</font><br
/><fontface="Arial" size="2">+ WHERE (((dbo_tbl_Terrein.RingCentraleNaam)='Oosterhout a/d Waal'));")</font><p><font
face="Arial"size="2">I get the following message:</font><p><font face="Arial" size="2">Error in
sqliteExecStatement(con,statement, bind.data) : </font><br /><font face="Arial" size="2">  RS-DBI driver: (error in
statement:no such column: dbo_tbl_Broedsels.BroedselID)</font><p><font face="Arial" size="2">( I also tried removing
the'dbo_tbl_'  part of the dataframe names, but still the same problem occurred)</font><br /><br /><p><font
face="Arial"size="2">Now ofcoarse I looked on google, because I was sure someone would have had the same problem.. And
yes,I found this website...</font><p><a href="http://code.google.com/p/sqldf/"><u><font color="#0000FF" face="Arial"
size="2">http://code.google.com/p/sqldf/</font></u></a><br/><p><font face="Arial" size="2">They say: </font><br /><span
lang="nl"><fontcolor="#0000FF" face="Times New Roman">This happens when you try to use variable with a dot in it (as
dotshave special meaning to SQL) or if you try to use SQL92 reserved keywords. SQLite/RSQLite replaces dots with
underscoresand changes keywords words so that they can be used. The keywords in question can be found by entering the
followingat the R command line: </font></span><p><span lang="nl"><font color="#0000FF" face="Courier New"
size="2">.SQL92Keywords</font></span><p><spanlang="nl"><font face="Courier New" size="2">In this list of keywords, i
cannotfind any word that is close to the error… So, i was wondering if someone knows how to solve it. preferably i do
notwant to change all variable names, as these names come from the 'big main database' of the
institute.</font></span><br/><p><span lang="nl"><font face="Courier New" size="2">The site also says that
SQLite/RSQLitecan fix the problem… but then when i look in their help, i cannot see how i can easily use those
commands…</font></span><p><spanlang="nl"><font face="Courier New" size="2">Anyone?</font></span><br /><p><span
lang="en-us"><fontface="Arial" size="2">Kind regards,</font></span><p><span lang="en-us"><font face="Arial"
size="2">Lucte Marvelde</font></span><br /><span lang="en-us"><font face="Arial" size="2">New member
:)</font></span><br/><br /><br /><br />