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

[Tim Fischer]

I'll try to answer everyone's questions at once here.

1) I cannot/will not use Windows.  I'm running FilePro on Solaris and mysql
on a FreeBSD box.  We have recently invested a TON of money (it almost made
me sick!) towards a truly amazing Sun/Solaris setup and I think the owner of
my company would kill me if I even came relatively close to mentioning
getting away from Sun.  :)

2) I need to be able to update in FilePro as well as in mysql (mostly web).
Therefore, this needs to be on a record by record basis.

3) Jay was exactly right in his explanation of my first post.
(Unfortunately, he said I can't do it!)

To give a little more detail to the situation, I have approximately 499
fields that need to be kept up to date.  (Some of those are not needed, but
we may end up just setting them all up so that it's really easy to add and
remove fields from the web.)

A temp file would work, but I'd really like to avoid it if possible.
Unfortunately, it looks like that's how we're going to have to do it.

I did look into the "USER" command and actually, that sounds like a great
utility!  Hopefully this will do the trick for us!

Thank you again for all of your suggestions!

-Tim 

> -----Original Message-----
> From: Kenneth Brody [mailto:kenbrody at bestweb.net] 
> Sent: Tuesday, May 11, 2004 9:34 PM
> To: Tim Fischer
> Cc: FilePro List
> Subject: Re: Reading from Standard In/Writing to Standard 
> Out? (on Solaris)
> 
> 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.
> 
> > 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.
> 
> -- 
> +-------------------------+--------------------+--------------
> ---------------+
> | Kenneth J. Brody        | www.hvcomputer.com |              
>                |
> | kenbrody at spamcop.net | www.fptech.com     | #include 
> <std_disclaimer.h> |
> +-------------------------+--------------------+--------------
> ---------------+
>