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

[Silas Martinez]

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.
>
>Does anyone use this or similar functionality anywhere?  Can you give me
>somewhere to look for instruction or assistance?
>  
>
We keep filepro and MySQL in sync, but its a matter of lots of text 
files, and regular cron jobs. Fortunately, we have a situation where a 
little time lapse doesn't hurt us, so we can get by with not being in 
perfect synch all the time. If that weren't the case (IE, if I needed 
real time or close to syncing) I'd probably look at something like 
system calls in processing, or a similar ugly kludge. But then, I'm not 
a fp guru - I just know enough to scratch by, and make things work how I 
need them to.  

>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!)
>  
>
Umm... maybe some black magic with fpodbc and your preferred odbc 
connectivity for mysql? Just guessing here - we are a linux/unix shop 
and have no interest in a windows install, or apps that are dependant on 
a windows install, sorry on that score.

>Thanks!
>
>Tim Fischer
>
>
>
>_______________________________________________
>Filepro-list mailing list
>Filepro-list at lists.celestial.com
>http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
>  
>
Silas Martinez
IT/MIS Micro Precision, Inc.