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

[Tim Fischer]

Ok, we've got an answer!! - Well, almost...

What we're doing is using the USER command and writing to an intermediary
script - basically, it's exactly what I was trying to do in the first place
- I've probably got to learn to word myself better.  :)

Anyway, now, my dilemma is that I can't close the user command.  In other
words - I'm writing 139 fields (to test - I'll actually be running live with
499 fields) to a text file (again, to test - I'll be running this to a
script eventually).  However, the text file isn't being created (the user
command isn't closing) until I close my rclerk session.  (I'm doing this
@key| right now).

Does anyone know how I can force the USER command to close?  The
documentation doesn't show anything.

Thanks!

-Tim

> -----Original Message-----
> From: filepro-list-bounces at lists.celestial.com 
> [mailto:filepro-list-bounces at lists.celestial.com] On Behalf 
> Of Tim Fischer
> Sent: Wednesday, May 12, 2004 8:52 AM
> To: 'FilePro List'
> Subject: RE: Reading from Standard In/Writing to Standard 
> Out? (on Solaris)
> 
> 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> |
> > +-------------------------+--------------------+--------------
> > ---------------+
> > 
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>