Reading from Standard In/Writing to Standard Out? (on Solaris)

[Jay R. Ashworth]

On Tue, May 11, 2004 at 09:34:01PM -0400, Kenneth Brody wrote:
> Tim Fischer wrote:
> > I've got a situation where I need to keep a mysql database in sync with our
> > FilePro database.  Our idea is to use Standard in/out as a medium to
> > transfer data.  I don't know, however, to get FP to read to standard in or
> > write to standard out.
> 
> Well, since filePro always reads from stdin and writes to stdout, I'm
> not sure exactly what you're asking.

It *is* acceptable to intuit what the user means in support situations,
Ken.

Clearly, what he means is "how do I write filePro code which can
programmatically interact with stdin and stdout, without filePro itself
getting in the way, so I can attach the code to something that speaks
mysql?" ... or something within 10 or 15% of that.

And the answer, of course, is, "you can't."

> > Does anyone use this or similar functionality anywhere?  Can you give me
> > somewhere to look for instruction or assistance?
> > 
> > Alternatively, is there a way to connect to a mysql server directly from FP?
> > (I'm guessing no, but it can't hurt to ask!)
> 
> You may be able to write wrappers around MySQL that filePro can call
> either with SYSTEM or interactively with USER.

That would be my recommendation as well; open a pipe to My's equivalent
of psql, and talk to it interactively.

Cheers,
-- jra
-- 
Jay R. Ashworth                                                jra at baylink.com
Member of the Technical Staff     Baylink                             RFC 2100
The Suncoast Freenet         The Things I Think
Tampa Bay, Florida        http://baylink.pitas.com             +1 727 647 1274

        "They had engineers in my day, too."  -- Perry Vance Nelson