On Mon, Nov 1, 2010 at 12:10 PM, Marc Schwartz <marc_schwa...@me.com> wrote: > On Nov 1, 2010, at 10:55 AM, Gabor Grothendieck wrote: > >> On Mon, Nov 1, 2010 at 10:55 AM, GL <pfl...@shands.ufl.edu> wrote: >>> >>> >>>> >>>> library(sqldf) >>> Loading required package: DBI >>> Loading required package: RSQLite >>> Loading required package: RSQLite.extfuns >>> Loading required package: gsubfn >>> Loading required package: proto >>> Loading required package: chron >>>> debug(sqldf) >>>> df.final <- sqldf('select Date, Hour, x as RoomsInUse from >>>> "df.possible.combos" >>> + left join "df.aggregate" using (Hour, Date)') >>> debugging in: sqldf("select Date, Hour, x as RoomsInUse from >> ... >>> debug: words. <- words <- strapply(x, "[[:alnum:]._]+") >>> Browse[2]> >>> Loading required package: tcltk >>> Loading Tcl/Tk interface ... >>> + >> >> There is something wrong with tcltk on your system. You can tell it >> not to use tcltk by setting the appropriate option as discussed in >> sqldf FAQ #5: >> >> http://code.google.com/p/sqldf/#5._I_get_a_message_about_tcl_being_missing. > > > GL, > > If you installed R using the OSX binary from CRAN, it does not include > tcl/tk. You need to install the separate tcltk package that Simon has put > together and is available from: > > http://cran.us.r-project.org/bin/macosx/tools/ > > You also need to have X11 installed, which is available from the OSX DVD in > the Optional Installs section. > > HTH, > > Marc Schwartz > > >
Note that sqldf can work without tcltk, as well. The gsubfn package does check for tcltk and and sets the engine to "R" rather than "tcltk" if capabilities()[["tcltk"]] is FALSE. There may be a bug in R or a problem with the installation. -- Statistics & Software Consulting GKX Group, GKX Associates Inc. tel: 1-877-GKX-GROUP email: ggrothendieck at gmail.com ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.