Re: anyone using FileMaker as oracle frontend ?
Posted: Oct 4, 2005 2:00 PM in response to: user454281 Reply
> Does anyone know where I can find more information
> about these “design patterns” for using FMP as a
> front-end to Oracle?
An example would be to use the built-in features of FileMaker Pro to create a FMP database based on the schema of the Oracle database:
1. Select File -> Open…, then “ODBC Data Source” from the “Show:” popup menu. Select your Oracle DSN and specify a SQL query. A new FMP database will be created with the data from your query.
2. Periodically refresh your FMP database with data from your Oracle database by first selecting Records -> Delete All Records, and then selecting File -> Import Records -> ODBC Data Source and specifying the same query as step #1 (this can be automated using the Import Records script step)
3. Update data in your Oracle database with data from your FMP database by writing a script similar to this:
Go to Record/Request/Page [First]
Execute SQL [No dialog; DSN: myDSN;
Calculated SQL Text: “UPDATE products_description
SET products_viewed=” & myFMPDatabase::Products_Viewed
& ” WHERE products_id=” & myFMPDatabase::Products_ID]
Go to Record/Request/Page [Next; Exit after last]
The script traverses the records in your FMP database and builds a SQL statement for updating a corresponding record in the Oracle database. A similar script could insert new records into the Oracle database.
Actual Technologies – ODBC for Mac OS X
Filed under: Internet