[R] sqldf hanging on macintosh - works on windows

[Gabor Grothendieck]

On Mon, Nov 1, 2010 at 12:10 PM, Marc Schwartz <marc_schwartz at me.com> wrote:
> On Nov 1, 2010, at 10:55 AM, Gabor Grothendieck wrote:
>
>> On Mon, Nov 1, 2010 at 10:55 AM, GL <pflugg at 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