[R] sqldf hanging on macintosh - works on windows

[Gabor Grothendieck]

On Mon, Nov 1, 2010 at 10:32 AM, GL <pflugg at shands.ufl.edu> wrote:
>
> added library(RH2)
>
> Still get message:
>
> Loading required package: tcltk
> Loading Tcl/Tk interface....
> +
>
> directly after sqldf statement
>
>>   df.final <- sqldf('select Date, Hour, x as RoomsInUse from
>> "df.possible.combos"
> +     left join "df.aggregate" using (Hour, Date)')
>
> There is no progress spinner. If I hit <enter> I get a ">"
>
> At that point I start to enter any command (just summary, for instance), I
> get the progress spinner, the
> "try(gsub('\\s+','',paste(capture.output(print(arg(summary))),collapse=")),silent=TRUE)
> " message in the bottom ribbon, and the system apparently hangs.

I don't have a Mac but if you wish to pursue it try this:

library(sqldf)
debug(sqldf)
sqldf(...whatever...)
# now step through it by repeatedly pressing Enter and send me the
console output of the session

-- 
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com