Apple script problems

[Jan Schenkel]

--- Jim Hurley <jhurley at infostations.com> wrote:
> 
> Jan,
> 
> I thought that Rev only communicated with certain
> select databases. 
>  From the doc under "revOpenDatabasse" it says:
> 
> 
>            The databaseType is one of
> "MySQL","Oracle" (Revolution 
> Enterprise only), "ODBC", "PostgreSQL", or
> "Valentina".
> 
> I tried a while back to work with one of these and
> was quickly 
> overwhelmed. Sarah was a big help but, in the end,
> it seems I was 
> better off sticking to my old technology, i.e.
> FileMaker => text file 
> => Run Rev => text file, and finally => FileMaker.
> Low tech, but it 
> works.
> 
> There is one possibility I haven't fully explored,
> and that is to use 
> AppleScript to import maybe half of the FMP file at
> a time into Run 
> Rev and then patching the two together in RR. I'm
> worried, however, 
> about transferring the pieces back into FMP from RR.
> 
> Jim
> 

Hi Jim,

You would connect to your FMPro database via ODBC
--though I'm not sure at which version FMPro started
supporting ODBC (4.1 ?)
This means you have to create a DSN (DataSourceName)
in the control panel, which points to the FMPro
database.
In RunRev you will refer to this DSN to open a
connection to the FMPro database. The Query Builder
makes it easy to create queries to tables, and then
you can use the Property Inspector to link RunRev
controls to fields in these queries.

If my memory serves me well, there was someone on the
list who actually linked RunRev to FMPro via its Web
Companion and liburl calls.
So there's plenty of solutions for the adventurous :)

Jan Schenkel.

=====
"As we grow older, we grow both wiser and more foolish at the same time."  (La Rochefoucauld)

__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree