[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Q:MCL,FoxPro,and AppleScript: can they cooperate?
- To: email@example.com
- Subject: Re: Q:MCL,FoxPro,and AppleScript: can they cooperate?
- From: firstname.lastname@example.org (Ken Anderson)
- Date: 26 Aug 94 09:04:45
- In-reply-to: email@example.com's message of Thu, 25 Aug 1994 21:19:02 GMT
- Newsgroups: comp.databases.xbase.fox, comp.lang.lisp.mcl
- Organization: BBN, Cambridge MA
- References: <schmitt.777849542@tartarus>
- Xref: services.cambridge.apple.com comp.databases.xbase.fox:5680 comp.lang.lisp.mcl:5806
In article <schmitt.777849542@tartarus> firstname.lastname@example.org (Kathryn Schmitt) writes:
I'd like to write an application in MCL that makes use of data coming from
a FoxPro database. I was planning on using Applescript to allow MCL to
send an SQL query to FoxPro, have FoxPro run the query, and then send the
results back to MCL. This is proving much more difficult than I anticipated.
For one thing, although FoxPro 2.5 claims to be AppleScriptable, this is only
in the very weakest sense of the term (as far as I can tell). It would be
nice for AppleScript to be able to refer to FoxPro objects, but this is not
possible. It looks as if I can have MCL write a file with an SQL query in
it, and then FoxPro can run it and print the results to another file, which
MCL can then read. Yuck! Is the way it has to be done?!?
Has anyone tried anything like this? Should I be looking into other Mac
database products? Any feedback appreciated!
Well, i'm not too far along, but am trying to do similar things. We don't
do an sql query, as at least at the moment, the "query" is fixed. We
output several files in comma separated values format. FOXPRO fires up the
MCL application which reads the files, does its work and produces another
set of files. I'll keep you posted on how this goes.
BBN ST Work Phone: 617-873-3160
10 Moulton St. Home Phone: 617-643-0157
Mail Stop 6/4a FAX: 617-873-2794
Cambridge MA 02138