Dan Bron <j...@bron.us> writes:
> If you're willing to update dbman (at least locally), I came across
> something during my earlier investigation that might provide you an
> alternative. But I'm not sure it'll work, or be useful if it does.
Dan, thanks for the follow-up, and thanks for the educational way in
which you answered my question. My apologies for the lack of a subject
line; I was posting from a Web interface while at work, and I simply
spaced it.
> Try replacing the line
>
> tbl=. y ddschtbl ch
>
> in ~addons\data\dbman\dbman.ijs with
>
> tbl=. <@:dltb"1 ] 2 {:: ddtblx ch [ require 'strings'
>
> it's the fourth line of the verb sel_schema, and the 177th line of the
> file.
Thanks. I forwarded it to myself at work, and I'll probably try it.
> But even if it does, I'm not sure how useful it will be. Sure, it'll get
> rid of the error message. But if you can't see any tables, what will you
> use dbman for?
I wonder the same thing. When I open the connection in Sequel Studio
Management Console (or whatever it's called), I see that bunches of
databases and tables inside those databases exist, but the only thing I
can look at currently AFAIK is a single view. Eventually, when the
application is finished, I'll have access to more views but still no
tables. If dbman only shows available tables when it opens, I may not
be able to navigate to the view I need, anyway.
At least I've demonstrated I can connect with dd in J as well as with
RODBC in R and with M-x sql-ms in Emacs.
Thanks,
Bill
--
Bill Harris http://facilitatedsystems.com/weblog/
Facilitated Systems Everett, WA 98208 USA
http://facilitatedsystems.com/ phone: +1 425 374-1845
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
