Database Reference
In-Depth Information
Set Web Viewer
ure 12-21
) can make your FileMaker layouts look and behave even more like a web browser.
With this flexible script step, you can make a series of buttons:
▪
Reset
sets the web viewer back to the web address that's specified in its Web Viewer
Setup dialog box.
▪
Reload
gets you a fresh copy of the web page you're currently viewing.
▪
Go Forward
lets you move forward through your web page history.
▪
Go Back
lets you move backward through the web pages you've been browsing.
▪
Go to URL
lets you specify any new web address via the Specify Calculation window.
But to use this script step, you have to refer to your web viewer by name. One cool thing
about referring to a web viewer by name is that you can display more than one web viewer
on a layout and then by using its name, choose which one your scripts address.
Figure 12-21. This Set Web Viewer dialog box is set to work on a web viewer with the name
“google webViewer.” When you select the “Go to URL” option, you see the same Set Web Viewer
dialog box that comes free with every web viewer.
Execute SQL
If you need to manipulate data in an ODBC data source, like Oracle, SQL, or MySQL, then
this script step is at your service (
Figure 12-22
). Unlike many other script steps, this one re-
quires some setup. You'll need an OBDC driver installed on any computer that runs an Ex-
ecute SQL script. Each driver is a bit different, so use the drivers' documentation for installa-
tion and setting up data sources. Finally, if you don't write SQL queries, then you need help
from someone who does, to make sure you get to the data you want. See
External SQL
Sources
to learn how you can use SQL data almost as easily as native FileMaker data.