FOR WINDOWS AND MAC OS Installation and New Features Guide ©1995, 1997-1998 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 http://www.filemaker.com FileMaker and ScriptMaker are trademarks of FileMaker, Inc, registered in the U.S. and other countries. All other trademarks are the property of their respective owners. This software is based in part on the work of the Independent JPEG group.
iii Contents Chapter 1: Welcome to FileMaker Pro About this guide Registration and customer support What you need to install FileMaker Pro Installation code Minimum hardware and software requirements Networking requirements Web publishing requirements Requirements for advanced features (Windows) Requirements for advanced features (Mac OS) Before you begin Upgrading from previous versions Updating your User Dictionary Opening files from previous versions 1-1 1-2 1-2 1-2 1-3 1-4 1-5 1-5 1-6 1-6 1-6 1-7 1-7
iv FileMaker Pro Installation and New Features Guide Chapter 3: Installing FileMaker Pro in the Mac OS Installing FileMaker Pro Starting the Installer Easy installation Custom installation Where files are stored on your hard disk FileMaker Pro 4.
Contents v Importing ODBC data: an overview An ODBC import example Installing the ODBC drivers Configuring the ODBC control panel Choosing the driver and data source Specifying the tables and columns in Windows Specifying the tables and columns in the Mac OS Importing from the data source Connecting to the data source from FileMaker Pro Specifying the SQL query in FileMaker Pro Importing the results of the query into FileMaker Pro Importing ODBC data with a join Specifying a SQL join Using ODBC import with
Chapter 1: Welcome to FileMaker Pro Welcome to the FileMaker® Pro 4.1 application. FileMaker Pro is designed to help you manage information easily and effectively. About this guide This FileMaker Pro Installation and New Features Guide tells you how to install the application on your Windows or Mac OS computer. Note When a feature or procedure is specific to a particular platform, you see instructions and illustrations that are also specific to that platform.
1-2 FileMaker Pro Installation and New Features Guide Registration and customer support If a product registration card was included with your software purchase, we encourage you to take the time to complete and mail it to us. In some products an electronic version of the registration card is included for your convenience. Please refer to our Web site at http://www.filemaker.com (http://www.filemaker.com/intl outside of North America) for information concerning customer and technical support.
Welcome to FileMaker Pro 1-3 Important You must enter the installation code during installation or the software will not install. The installation code ensures adherence to the single user license agreement, which allows for use of one (1) copy of the Software on a single computer at a time (refer to your Software License).
1-4 FileMaker Pro Installation and New Features Guide Note ODBC import is not supported in 680x0 Macintosh computers and Web publishing is not supported in 68000 Macintosh computers. Memory settings In the Mac OS, to see the minimum and preferred application memory settings for FileMaker Pro, select the FileMaker Pro application icon after installation and choose Get Info from the File menu. For information about adjusting the memory allocated to FileMaker Pro, see “Adjusting memory” on page 3-8.
Welcome to FileMaker Pro 1-5 You can use one of the following solutions to share files on a mixed Windows and Mac OS network. Windows 98 or Windows 95 Windows NT Windows for Workgroups Windows 3.1 Mac OS Microsoft TCP/IP-32 version 3.11b Network TeleSystems TCP Pro 3.0 or later MacTCP 2.0.6 or later or Open Transport 1.
1-6 FileMaker Pro Installation and New Features Guide The DLL and the API files are installed with a Typical installation of Windows 98, Windows 95, Windows NT 3.51 and Windows NT 4.0. Requirements for advanced features (Mac OS) FileMaker Pro advanced feature Software requirement ODBC import Install ODBC program files and drivers located in the FileMaker Pro 4.1 CD-ROM (ODBC import is not supported on 680x0 Macintosh computers) URL support Internet Config 1.
Welcome to FileMaker Pro 1-7 Updating your User Dictionary If you have added words to your User Dictionary in either a previous version of FileMaker Pro or another FileMaker, Inc. (or Claris) product, then you must export that User Dictionary to a text file, then import it into the User Dictionary in FileMaker Pro 4.1. To export the User Dictionary from FileMaker Pro 2.x and later: 1. In your previous version of FileMaker Pro, choose Spelling from the Edit menu, then choose User Dictionary. 2.
1-8 FileMaker Pro Installation and New Features Guide To convert and open a FileMaker Pro 2.x file: 1. Start FileMaker Pro 4.1. 2. Choose Open from the File menu and select the file you want to convert in the Open dialog box. You see the Conversion dialog box. 3. Click OK to append “Old” to the name of the original FileMaker Pro 2.x file. 4. After you click OK, you see another dialog box where you can name the new, converted file. By default, this converted file will have the original file’s name.
Chapter 2: Installing FileMaker Pro in Windows Before you begin the installation process, exit other open programs and save your work, and turn off virus protection utilities. Note For instructions on installing FileMaker Pro on a Mac OS–based computer, see chapter 3, “Installing FileMaker Pro in the Mac OS.” Installing with Windows 98, Windows 95 or Windows NT 4.0 You must use the installation program to install FileMaker Pro—you can’t install FileMaker Pro by dragging files to your hard disk.
2-2 FileMaker Pro Installation and New Features Guide 4. Click Accept to agree to the terms of the license agreement. You see the Welcome screen. 5. Click Next. You see the FileMaker Pro Installation dialog box. Follow the steps described in one of the following sections: 1 If you want to install all the available files, continue with Typical installation. 1 If you want to install a subset of the FileMaker Pro files, skip to “Compact installation or Custom installation” on page 2-5.
Installing FileMaker Pro in Windows 2-3 Typical installation Follow these steps to install the complete FileMaker Pro package on your Windows 98, Windows 95 or Windows NT 4.0 system. To install all the FileMaker Pro files on your hard disk: 1. If you have not already done so, insert the CD-ROM. Follow the instructions on page 2-1. 2. In the FileMaker Pro Installation dialog box, choose Typical. If you want to install FileMaker Pro in another folder or on another drive, click the Browse button.
2-4 FileMaker Pro Installation and New Features Guide Otherwise, you see the Personalization dialog box. Type your name here Type your installation code here 5. In the Name box, type your name and press the Tab key. 6. Type your company name, if applicable, and press Tab. If you don’t have a company name, you can put other information (like your address) in the box or leave it blank. 7. In the Installation Code box, type your FileMaker Pro installation code.
Installing FileMaker Pro in Windows 2-5 Compact installation or Custom installation To install a subset of FileMaker Pro files on your hard disk: 1. If you have not already done so, insert the CD-ROM. Follow the instructions on page 2-1. 2. In the FileMaker Pro Installation dialog box, choose Compact or Custom. If you want to install FileMaker Pro in another folder or on another drive, click the Browse button.
2-6 FileMaker Pro Installation and New Features Guide 3. Click Next. If you’ve selected Custom, the dialog box lists the files you can install. Files you can install 4. For a Custom installation, click to the left of an item to select the files you want to install. Any file with a checkmark will be installed. 5. Click Next. If you are installing the FileMaker Pro application, you see the Personalization dialog box. 6. In the Name box, type your name and press the Tab key. 7.
Installing FileMaker Pro in Windows 2-7 If you’ve made an error in typing, follow the instructions provided on the screen. 10. Click Next. The Installer begins copying files. A dialog box tells you what the Installer is doing. After the selected files are installed, a final dialog box tells you the installation on your hard drive was successful. If you’ve installed the FileMaker Pro application, the installation program creates a menu item for FileMaker Pro in the Start menu.
2-8 FileMaker Pro Installation and New Features Guide Typical installation To install FileMaker Pro with Windows 3.1, Windows for Workgroups 3.11, or Windows NT 3.51: 1. Start Windows. 2. Insert the CD-ROM into the CD-ROM drive. 3. Choose Run from the Program Manager’s File menu. 4. Type the drive letter for the CD-ROM drive and the path for the setup command in the Command Line box (for example, d:\setup) and click OK. 5. Follow the installation instructions provided on the screen.
Installing FileMaker Pro in Windows 2-9 Contents of the FileMaker Pro 4.1 and fmpro41 folders This table shows the location and contents of items installed in a Typical installation. Folder location in Windows 95, Windows 98 and Windows NT 4.0 Folder location in Windows 3.1, Windows for Workgroups, and Windows NT 3.51 C:\Program Files\FileMaker\ FileMaker Pro 4.1 C:\fmpro41 File or folder Description FILEMAKER PRO.EXE Application file (FMPRO.EXE in Windows 3.1, and Windows for Workgroups) README.
2-10 FileMaker Pro Installation and New Features Guide Folder location in Windows 95, Windows 98 and Windows NT 4.0 Folder location in Windows 3.1, Windows for Workgroups, and Windows NT 3.51 C:\Program Files\FileMaker\ C:\fmpro41\web tools FileMaker Pro 4.1\Web Tools (Windows NT 3.51 only) C:\Program Files\FileMaker\ FileMaker Pro 4.1\Web Security C:\fmpro41\web security (Windows NT 3.51 only) C:\Program Files\FileMaker\ FileMaker Pro 4.1\Odbc C:\Program Files\FileMaker\ FileMaker Pro 4.1\System Fil
Installing FileMaker Pro in Windows 2-11 Folder location in Windows 95, Windows 98 and Windows NT 4.0 Folder location in Windows 3.1, Windows for Workgroups, and Windows NT 3.51 File or folder Description FMCGM32.FLT CGM graphic filter FMDRW32.FLT DRW graphic filter FMMAC32.FLT MacPaint graphic filter FMPCX32.FLT PCX graphic filter FMPIC32.FLT PIC graphic filter FMSLD32.FLT Lotus SLD graphic filter FMTIFF32.FLT TIFF graphic filter FMWMF32.FLT Metafile graphic filter CTL3D32.
2-12 FileMaker Pro Installation and New Features Guide Adjusting the FileMaker Pro cache FileMaker Pro maintains an internal cache of portions of your database. Depending on your computer’s memory configuration, you may want to adjust the cache size to improve performance.
Installing FileMaker Pro in Windows 2-13 3. Type a number in the Attempt cache size of box. 4. Click Done. The next time you start FileMaker Pro, the new cache size is used. Adjusting network software Depending on the networking protocol you’re using, you may have to modify settings on the host and/or guest computers. Changing the network protocol During installation, you select a network protocol (or No Networking) for FileMaker Pro. You can change the network protocol at any time.
2-14 FileMaker Pro Installation and New Features Guide 3. Choose a network protocol from the Network Protocol drop-down list. Note In Windows 3.1, FMIPX32.NET and FMTCP32.NET appear in the drop-down list. Changes to this setting don’t take effect until you exit FileMaker Pro and then start it again. IPX/SPX Considerations Windows 98, Windows 95 or Windows NT To allow the maximum number of guests (25), your IPX/SPX connections must be set to 60 or greater.
Installing FileMaker Pro in Windows 2-15 To share FileMaker Pro database files: 1 Use the Windows Setup program to set the network to the appropriate NetWare option (usually NetWare 3.26 or later). 1 Add the following entries to your NET.CFG (or SHELL.CFG) file: GET LOCAL TARGET STACKS=10 SPX CONNECTIONS=40 Get local target stacks needs to be set on all guest machines.
2-16 FileMaker Pro Installation and New Features Guide Changing the frame type in Windows NT To change the frame type with IPX/SPX networking: 1. Right-click Network Neighborhood. 2. Select Properties from the menu. You see the Network dialog box. 3. Click the Protocols tab. 4. Click NWLink IPX/SPX. 5. Click Properties. 6. Select a frame type from the drop-down list. 7. Click OK to apply the frame type. 8. Click OK to close the Network dialog box.
Chapter 3: Installing FileMaker Pro in the Mac OS Before you begin the installation process, quit other open programs and save your work, and turn off virus protection utilities. Note: For instructions on installing FileMaker Pro on a Windows-based computer, see chapter 2, “Installing FileMaker Pro in Windows.” Installing FileMaker Pro You must use the installation program to install FileMaker Pro—you can’t install the application by dragging files to your hard disk.
3-2 FileMaker Pro Installation and New Features Guide To install FileMaker Pro on your hard disk: 1. If you have not done so already, start the Installer, as described on page 3-1. You see the FileMaker Pro Installer dialog box. Choose Easy Install Location where FileMaker Pro will be installed 2. Specify the installation location, or use the default location.
Installing FileMaker Pro in the Mac OS 3-3 You see the Personalize dialog box. Type your name here Type your Iistallation code here 4. In the Name box, type your name and press the Tab key. 5. Type your company name, if applicable, and press Tab. If you don’t have a company name, you can put other information (like your address) in the box or leave it blank. 6. Type your FileMaker Pro installation code.
3-4 FileMaker Pro Installation and New Features Guide 8. If you are installing the MacIPX networking software, click Continue. (You must do a Custom Installation to install MacIPX. See the next section, “Custom installation.”) Otherwise, click Quit to leave the Installer. 9. If you turned off virus protection and file sharing before installing, turn them back on now. Custom installation To install a subset of FileMaker Pro files on your hard disk: 1.
Installing FileMaker Pro in the Mac OS 3-5 1 If the selected disk doesn’t have enough space for the files you select, you see a message. In the Finder software, you can delete existing files to make more room on the disk. You can also choose not to install some files (like the tutorial or template files) by deselecting those files in the scrolling list. 5. Click Install. If you’ve selected the application, you see the Personalize dialog box. 6. In the Name box, type your name and press the Tab key. 7.
3-6 FileMaker Pro Installation and New Features Guide Where files are stored on your hard disk The following table shows the files and folders you can install, and the preferred location for them on your hard disk. If you install onto the current system disk, the FileMaker Pro Installer places all the files you need in their preferred locations. FileMaker Pro 4.1 Folder This table shows the files and folders installed in the FileMaker Pro Folder. FileMaker Pro 4.
Installing FileMaker Pro in the Mac OS 3-7 FileMaker Pro 4.
3-8 FileMaker Pro Installation and New Features Guide Adjusting memory The Mac OS sets aside a certain amount of memory for FileMaker Pro.
Installing FileMaker Pro in the Mac OS 3-9 3. Choose Get Info from the File menu. You see the FileMaker Pro Info window. Change the amount of memory FileMaker Pro uses here 4. In the Memory Requirements area at the bottom of the window, double-click the Preferred size number and type a number to change the memory allocated for FileMaker Pro. If you can’t type in the box, make sure you’ve quit FileMaker Pro. 5. Click the close box.
3-10 FileMaker Pro Installation and New Features Guide To choose a network protocol: 1. Choose Preferences from the Edit menu, and then choose Application. You see the Application Preferences dialog box. If necessary, choose General from the pop-up menu at the top of the dialog box. 2. Choose a network protocol from the Network protocol pop-up menu. 3. Click Done. Changes to this setting don’t take effect until you quit FileMaker Pro and then start it again.
Chapter 4: New features in FileMaker Pro This chapter introduces the new features in FileMaker Pro 4.1 and FileMaker Pro 4.0. ODBC import FileMaker Pro 4.1 enables you to import data via Open Database Connectivity (ODBC). If you have ODBC drivers installed and configured, you can import data from a number of ODBC-compatible data sources, including Oracle databases. The drivers query the data source using Structured Query Language, or SQL, to determine which records are imported.
4-2 FileMaker Pro Installation and New Features Guide Support for custom menu items Using FileMaker Pro Developer Edition, database developers can customize the name of the Script menu, connect a script to a custom menu item in the Help menu, and connect a script to “About ” (under the Help menu in Windows and under the Apple menu in the Mac OS). If a menu name is altered in the runtime solution, the custom menu name will replace the menu name in the FileMaker Pro 4.1 file you’re viewing.
New features in FileMaker Pro 4-3 Web publishing capabilities Using FileMaker Pro 4.0 and 4.1, you can access your database from almost anywhere in the world. Your file can be viewed, edited, sorted, and searched with just Web browser software and access to the Internet or your intranet. You can also choose how much or how little access other users have to your file. Note Access to the Internet requires an Internet service provider. FileMaker Pro does not provide an Internet account for you.
4-4 FileMaker Pro Installation and New Features Guide Custom Web Publishing You can create a complete, custom, interactive Web solution using the FileMaker Pro Web Companion and dynamic HTML files. FileMaker Pro now can publish HTML documents containing GIF and JPEG graphics, animated GIF files, QuickTime movies, and AIFF files. In addition, FileMaker Pro 4.0 and 4.1 support any custom Java applets designed by a developer using the FileMaker Pro Developer Edition.
New features in FileMaker Pro 4-5 URL support With FileMaker Pro 4.0 and later, you can open a URL from a field. To open a URL in Windows, right-click a URL in a field and choose Open from the context menu. In the Mac OS, command-click a URL in a field. If the address is for a Web page, FileMaker Pro opens your Web browser software. Open URL script step You can create a script that opens a Web browser and goes to a specified URL.
4-6 FileMaker Pro Installation and New Features Guide Layout and interface enhancements Fields and objects can be rotated in 90-degree increments, allowing greater flexibility in your layouts. Text can also be dragged and dropped into a rotated text block. To make creating and managing your files easier, value lists can be defined from the File menu. Recently opened documents are listed in the File menu on both the Mac OS and Windows platforms.
Chapter 5: ODBC import with FileMaker Pro This chapter explains how to import data from ODBC sources, a new feature in FileMaker Pro 4.1. See the FileMaker Pro User’s Guide for information about importing other file types. What is ODBC? Open Database Connectivity (ODBC) is a standard language that enables compliant applications to access data from many different database management systems (DBMSs). It allows an application accessing data, for example, FileMaker Pro 4.
5-2 FileMaker Pro Installation and New Features Guide Term Refers to Structured Query Language or SQL A programming language that controls and interacts with a DBMS (for example, is used by ODBC to access data). Data source The specific data that you want to access, including the DBMS that is storing the data. For example, a DBMS can be an Oracle database on a network or a text file or Microsoft Excel table from your hard drive.
ODBC import with FileMaker Pro 5-3 FileMaker Pro is certified with the following ODBC data sources and drivers: Platform Certified ODBC data sources Mac OS Oracle 7 (INTERSOLV) Text (INTERSOLV) Windows 98, Windows 95, Windows NT Microsoft Excel (INTERSOLV, Microsoft) Microsoft Access (Microsoft) Oracle 7 (INTERSOLV) SQL Server (INTERSOLV, Microsoft) Text (INTERSOLV, Microsoft) The Microsoft Excel and Microsoft Access ODBC drivers are available with Microsoft Office.
5-4 FileMaker Pro Installation and New Features Guide Use the Where clause to further narrow down the records being retrieved. For example, use the greater than (>) operator to return records where the amount sold is greater than 3,000: SELECT Sales_data.Company_Name, Sales_data.Amount FROM Sales_data WHERE Sales_data.Amount > 3000 You can also reduce the number of records by creating a join with another column. For more information, refer to the example in “Specifying a SQL join” on page 5-17.
ODBC import with FileMaker Pro 5-5 Importing ODBC data: an overview The procedures to import ODBC data can vary depending on which driver you are using. For example, the steps to import data using the Oracle or SQL Server ODBC driver vary from the steps using the Text driver. Additionally, steps may vary from one ODBC driver manufacturer to another. Refer to the documentation available in the retail version of the ODBC driver for more information. Here are general steps to import ODBC data: 1.
5-6 FileMaker Pro Installation and New Features Guide Note The instructions provided work with Windows 98, Windows 95, Windows NT, and Mac OS 8.0. If you’re using Mac OS system 7.6.1 or earlier and have not installed the Appearance Manager extension, options presented in dialog box tabs will appear in pop-up menus. Choose SQL clauses from pop-up menus in Mac OS 7.6.1 and earlier Choose SQL clauses from tabs in Mac OS 8.0 and later The FileMaker Pro query builder dialog box in Mac OS 7.6.
ODBC import with FileMaker Pro 5-7 Windows: To install the trial ODBC drivers in Windows 98, Windows 95, or Windows NT, double-click the Setup.exe icon in the ODBC Installer folder inside the ODBC folder. Follow the onscreen installation instructions, and choose the default behavior where possible. When prompted for product registration information, type your name, company name, and type eval in the serial number box. Leave the Registration Key blank.
5-8 FileMaker Pro Installation and New Features Guide 3. Click Finish. 4. In the General Tab of the ODBC Driver Setup dialog box, begin configuring the driver by specifying the data source name. For this example, type ODBC Demo. 5. Supply a description of the data source in the Description box. The description can be whatever you choose. For this example, type ODBC Import into Sales Reports.fp3. 6. In the Database Directory box, specify the path to the data source. Windows: Type the path: C:\Program Fil
ODBC import with FileMaker Pro 5-9 Mac OS: Click the Select Directory button and locate the folder containing the data source (the ODBC Example folder, inside the ODBC folder in the FileMaker Pro 4.1 folder). Click Select ODBC Example. Add ODBC columns in the Define tab Specify the data source name, description, and directory Mac OS ODBC Setup PPC control panel 7. Select the Column Names in First Line checkbox. 8. Click the Advanced Tab to specify additional settings. 9.
5-10 FileMaker Pro Installation and New Features Guide Leave the control panel open and continue to the next section. Choose Guess Definition to retrieve column names Click Define to specify ODBC tables Advanced options in the Text ODBC control panel (Windows) Specifying the tables and columns in Windows After choosing and configuring the ODBC text driver in the ODBC control panel, you specify the tables and columns to import. 1. In the Advanced tab of the Windows ODBC control panel, click Define. 2.
ODBC import with FileMaker Pro 5-11 It may take a few moments to retrieve the column names. Click Guess to insert column names Select to retrieve column names from the ODBC table 6. Select the Date_Sold column and verify that the Type and Mask values are correct. The Type should be Date, and the Mask should be m/d/yy. When importing columns that store date information, you should verify that the driver recognizes the correct column type and mask, especially if the data source is from a Unix computer. 7.
5-12 FileMaker Pro Installation and New Features Guide 3. For column information, click the Guess button. The ODBC driver will attempt to retrieve the column names from the specified table. It may take a few moments to retrieve the column names. Click Guess to insert column names Select to retrieve column names from the ODBC table 4. Specify the information for the Salespeople table. In the Table list, choose Salespeople. You’ll be prompted to save changes to the table definition. Click Yes. 5.
ODBC import with FileMaker Pro 5-13 Connecting to the data source from FileMaker Pro To specify the data source in FileMaker Pro: 1. Open the FileMaker Pro database file you’ll import data into. For this example, open the Sales Reports database file, located in the ODBC Example folder. 2. In Browse mode, choose Import/Export from the File menu, then choose Import Records. 3. Choose the file import format. Windows: For Files of type, select ODBC Data Source. Mac OS: Select ODBC in the Show pop-up menu.
5-14 FileMaker Pro Installation and New Features Guide For this example, select ODBC Demo, the data source name you specified in the previous section, “Configuring the ODBC control panel.” Select the ODBC data source you previously configured 5. If appropriate, enter the user name and password for the data source you selected, and click OK. If a user name and password appear, delete them and click OK to proceed. The ODBC example files have no user name or password.
ODBC import with FileMaker Pro 5-15 2. In the Select tab, click the table you’ll import from. Specify the columns from each table to insert into the SQL query Click to add choices into the SQL query below As you make choices in each tab, the SQL query is automatically generated Click to begin the SQL query SQL statement retrieves four columns from the Salespeople table For this example, select the Salespeople table. The columns associated with the Salespeople table appear. 3.
5-16 FileMaker Pro Installation and New Features Guide Importing the results of the query into FileMaker Pro After building the SQL query in the Specify ODBC SQL Query dialog box, you’re ready to import the resulting records into FileMaker Pro. 1. In the FileMaker Pro Import Field Mapping dialog box, match the fields you want to import on the right with the data source columns on the left by selecting Matching Names from the View By list.
ODBC import with FileMaker Pro 5-17 Importing ODBC data with a join Use the Where tab in the FileMaker Pro query builder to create a multi-table SQL query, or join. A join combines data from two or more tables into a new table. Specifying a SQL join In this example, we want to view a report that contains information about sales transactions (from the Sales_Data table) along with information about the salesperson (from the Salespeople table).
5-18 FileMaker Pro Installation and New Features Guide To access the FileMaker Pro query builder, choose Import/Export then Import Records from the File menu, then the ODBC file format. Refer to “Importing from the data source” on page 5-12 for more information. To do a join: 1. In the Specify ODBC SQL Query dialog box, click Clear Query to remove the SQL statement from the SQL Query box. To confirm that you want to delete the query, click Clear. 2. In the Select tab, click the Sales_Data table.
ODBC import with FileMaker Pro 5-19 Creating a SQL join Using the Where SQL clause 12. Click the Order By tab to sort the records before importing them into FileMaker Pro. 13. Select the name of the column to sort by, Sales_Data.Amount. 14. Click Descending to sort the records from highest amount sold to lowest amount sold. 15. Click Move. 16. Click Insert into SQL Query. 17. Click Execute. 18.
5-20 FileMaker Pro Installation and New Features Guide SQL query using all three clauses: Select, Where, and Order By You can use the Sales Reports database to view reports of your data. Click Reports to select summary reports on the ODBC data The SQL query imported 250 records from both data source tables ODBC data imported into the Sales Reports database To view a summary report of total sales for each salesperson, click the Reports button, then the By Salesperson button.
ODBC import with FileMaker Pro 5-21 Choose a report in the Sales Reports database Using ODBC import with ScriptMaker As with other import script steps, you can create an ODBC script that hides all dialog boxes during an ODBC import. Because FileMaker Pro interacts with an ODBC driver, however, some options behave differently than when used with other scripted imports: 1 The Restore import order option stores the field order in the Import Field Mapping dialog box, similar to other scripted imports.
5-22 FileMaker Pro Installation and New Features Guide ODBC considerations Keep the following considerations in mind when importing data using ODBC: 1 The ODBC drivers included with FileMaker Pro 4.1 are for evaluation purposes only; visit the INTERSOLV Web site (http://www.intersolv.com) for purchasing information or check with the application providing the data source for other ODBC drivers. 1 Different ODBC drivers might present very different configuration interfaces.
Appendix A: MacIPX control panel You can use the MacIPX control panel to: 1 select the network interface for your applications that use MacIPX 1 change the parameters that MacIPX uses (if necessary) Important For enhanced performance, TCP/IP is recommended. Using an Ethernet or token-ring network interface for MacIPX The MacIPX control panel displays icons for the available network interfaces, such as Ethernet, AppleTalk, and token ring.
A-2 FileMaker Pro Installation and New Features Guide After you select the IPX interface, the control panel displays the network number and node number of your Macintosh on the selected interface The software on your computer system determines which icons you see. 3. Click OK, and then close the MacIPX dialog box. Note MacIPX 1.3.1 supports most Ethernet interface cards, as well as the token-ring interface card from Apple Computer.
MacIPX control panel A-3 To have MacIPX select the frame type: 1. In the MacIPX control panel, double-click the selected network interface icon. You see the Access Configuration dialog box for your chosen network interface. For example, if you click the Ethernet icon, you see the Ethernet Access Configuration dialog box, where you can set parameters for working with Ethernet. The dialog box shows the currently selected frame type 2.
A-4 FileMaker Pro Installation and New Features Guide To have MacIPX determine the appropriate frame type at any moment: 1. In the Access Configuration dialog box, click Auto-Configure Frame Type Now. Then click OK to dismiss the message. In the dialog box, MacIPX highlights buttons in sequence until it determines the appropriate frame type. 2. Click OK to close the dialog box.
MacIPX control panel A-5 3. Click Always Auto-Select an IPX Gateway from the Selected Zone. 4. Click OK to close the dialog box. When the computer starts up and detects that it’s connected to an AppleTalk networking interface, such as LocalTalk, it selects an appropriate IPX gateway in the specified zone. In some cases (for example, if you get an error message), you need to select the gateway yourself. To select an IPX gateway yourself: 1.
A-6 FileMaker Pro Installation and New Features Guide Setting advanced MacIPX parameters From the MacIPX control panel, you can set other parameters that affect MacIPX operations. Important Only a certified network engineer or administrator should change the advanced parameters. Changing the parameters without a good understanding of their functions can adversely affect the performance of MacIPX. For more information, see your network administrator or contact your Novell dealer.
MacIPX control panel A-7 Use the information in the following tables to set parameters for: 1 1 1 1 MacIPX SPX (Sequenced Packet Exchange) SAP (Service Advertising Protocol) RIP (Routing Information Protocol) MacIPX parameter Function Disable IPX Diagnostic Services Disables the IPX Diagnostic Services, used by some network management tools. Disabling IPX Diagnostic Services can reduce the amount of memory that MacIPX uses.
A-8 FileMaker Pro Installation and New Features Guide SPX parameter Function Default Retry Count Specifies the maximum number of times that SPX attempts to retransmit a packet before determining that the packets can’t be sent, and then closes the connection. The default value is 10 times. An application can override the value in this field. Minimum Retry Count Specifies the minimum number of times that an SPX packet must be retransmitted.
Appendix B: Installing Win32s If you are using Windows 3.1 or Windows for Workgroups 3.11, you need to install Win32s 1.30c before installing FileMaker Pro. After installing Win32s, you will still be able to run all the applications you currently use. If an earlier version of Win32s is installed on your system, you must first remove the older version. To determine the version of Win32s that’s installed on your computer: 1. In the File Manager, click WIN32S16.DLL, located in the \WINDOWS\SYSTEM directory.
B-2 FileMaker Pro Installation and New Features Guide 5. Delete all the files in the \\WIN32S subdirectory or the \WIN32S subdirectory in network installations. Then delete the WIN32S directory itself. The above changes take effect the next time you run Windows. Note refers to the Windows installation directory. On a networked Windows installation, the system directory may be located on a shared remote volume.
Installing Win32s B-3 5. Click OK. If you made changes, you need to restart Windows before installing Win32s. 6. In the File Manager, open the Disk 1 directory that’s in the Win32s directory on the FileMaker Pro CD-ROM. 7. Double-click the SETUP.EXE program and follow the Win32s setup instructions. 8. When the Win32s installation is complete, the FreeCell Setup dialog box appears. 9. FileMaker, Inc.
