Meng-Connect-kan FMP dengan Oracle


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]
Loop
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]
End Loop

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.

Best regards,

Jonathan Monroe
Actual Technologies – ODBC for Mac OS X
http://www.actualtechnologies.com
monroej@actualtechnologies.com

Tinggalkan Balasan

Please log in using one of these methods to post your comment:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s

%d blogger menyukai ini: