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

[Fairlight]

This public service announcement was brought to you by Walter Vaughan:
> 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.
> 
> The easy answer is to use fpODBC on WindowsXP and dump Solaris.

Dear me.  Well, if you don't really care about security, or you're
firewalled to hell and back, I guess so...  :)

> Or are you looking for something on a record level that would
> do something similar to the above but for single records?

Well, simply using USER to a tiny perl script written with DBI and
DBD::mysql would work on a per-record basis so that you could populate
mysql with data as you get it in fP.  Now the other way around?  That's a
bit dicier, but also doesn't appear to be indicated in this request.

I suppose you could use the mysql client with a completely written SQL
file as well.  I'm just used to approaching it from another angle.

> This is NOT a simple issue, and the fact that fpODBC will not exist
> for Unix OS's in the near future is cause for reflection as to what
> is your long term filePro strategy.

s/near future/ever, in all probability,/

Scuttlebutt says it's likely it will -never- happen.  That's nothing
official.  Just back-channel scatter in the community.  There are
apparently technical reasons I've been made aware of.  I choose not to
comment on those reasons, in the interests of peace.  :)

mark->
-- 
Bring the web-enabling power of OneGate to -your- filePro applications today!

Try the live filePro-based, OneGate-enabled demo at the following URL:
               http://www2.onnik.com/~fairlite/flfssindex.html