FACTOID # 32: Guatamalan women work 11.5 hours a day, while South African men work only 4.5.
 
 Home   Encyclopedia   Statistics   Countries A-Z   Flags   Maps   Education   Forum   FAQ   About 
 
WHAT'S NEW
RELATED ARTICLES
People who viewed "Filemaker" also viewed:
RECENT ARTICLES
More Recent Articles »
 

FACTS & STATISTICS    Simple view

  1. Select countries to view: (hold down Control key and click to select several)

     

     

    Compare:

     

     

  1. Select fact or statistic: (* = graphable)

     

     

     

  2. (OPTIONAL) Compare to statistic: (both need to be graphable)

     

     

     

  3. View result as:

     

       
(OR) SEARCH ALL encyclopedia, stats & forums:   

Encyclopedia > Filemaker
FileMaker Pro
Image://icon prod family fmp8.png
Developer: FileMaker Inc.
Latest release: Version 9.0 / July 10, 2007
OS: Mac OS X, Windows XP
Genre: Database management system
License: Proprietary
Website: FileMaker Inc.

FileMaker Pro is a cross-platform database application from FileMaker Inc. (a subsidiary of Apple Inc.), known for its combination of power and ease of use. It is also noted for the integration of the database engine with its GUI-based interface, which allows users to modify the database by dragging new elements into the layouts/screens/forms that provide the user interface. This results in a "quasi-object" development environment of a kind that is still largely unique in the "industrial strength" database world. “Software development” redirects here. ... FileMaker Inc. ... Code complete redirects here. ... is the 191st day of the year (192nd in leap years) in the Gregorian calendar. ... Year 2007 (MMVII) is the current year, a common year starting on Monday of the Gregorian calendar and the AD/CE era in the 21st century. ... An operating system (OS) is the software that manages the sharing of the resources of a computer and provides programmers with an interface used to access those resources. ... Mac OS X (pronounced ) is a line of graphical operating systems developed, marketed, and sold by Apple Inc. ... Windows redirects here. ... Computer software can be organized into categories based on common function, type, or field of use. ... A database management system (DBMS) is computer software designed for the purpose of managing databases. ... A software license is a legal agreement which may take the form of a proprietary or gratuitous license as well as a memorandum of contract between a producer and a user of computer software. ... Proprietary software is software with restrictions on copying and modifying as enforced by the proprietor. ... A website (alternatively, Web site or web site) is a collection of Web pages, images, videos or other digital assets that is hosted on one or several Web server(s), usually accessible via the Internet, cell phone or a LAN. A Web page is a document, typically written in HTML... This article is about computing. ... FileMaker Inc. ... A subsidiary, in business, is an entity that is controlled by another entity. ... Apple Inc. ... A dfgyfgdcdfgis the underlying component that a Database Management System (DBMS) uses to create, retrieve, update and delete (CRUD) data from a database. ... GUI can refer to the following: GUI is short for graphical user interface, a term used to describe a type of interface in computing. ...


FileMaker was one of a handful of database applications released for the Apple Macintosh in the 1980s. The first Macintosh computer, introduced in 1984, upgraded to a 512K Fat Mac. The Macintosh or Mac, is a line of personal computers designed, developed, manufactured, and marketed by Apple Computer. ...


FileMaker has compatible versions for both the Mac OS X and Microsoft Windows operating systems and can be networked simultaneously to a mixed Windows and Mac OS X user base. FileMaker is also scalable, being offered in desktop, server, web-delivery and mobile configurations. Mac OS X (pronounced ) is a line of graphical operating systems developed, marketed, and sold by Apple Inc. ... Windows redirects here. ... In telecommunications and software engineering, scalability indicates the capability of a system to increase performance under an increased load when resources (typically hardware) are added. ...

Contents

History

FileMaker began as a DOS-based product known as “Nutshell,” developed by Nashoba Systems of Concord, Massachusetts around 1982 or 1983. Nutshell was distributed by Leading Edge, an electronics marketer that had recently started selling PC-compatible computers and software. This article is about the family of closely related operating systems for the IBM PC compatible platform. ... Location in Middlesex County in Massachusetts Coordinates: , Country State County Middlesex Settled 1635 Incorporated 1635 Government  - Type Open town meeting Area  - Total 25. ... This article is about the U.S. state. ... Leading Edge Hardware Products, Inc. ...


With the introduction of the Macintosh, Nashoba combined the basic data engine with a new forms-based GUI, creating a program that was dramatically easier to use. Leading Edge was not interested in the product, preferring to remain a DOS-only vendor, and kept the Nutshell name. Nashoba found another distributor, Forethought Inc., and introduced it to the Mac market as “FileMaker.” When the Macintosh Plus was introduced, the next version of FileMaker was named “FileMaker Plus” to reflect the computer’s name. For other uses, see Macintosh (disambiguation) and Mac. ... GUI can refer to the following: GUI is short for graphical user interface, a term used to describe a type of interface in computing. ... Forethought, Inc. ... The Macintosh Plus computer was the third model in the Macintosh line, introduced two years after the original Macintosh and a little more than a year after the Macintosh 512K. It originally had a beige case, but in 1987, the case color was changed to the long-lived platinum color. ...


Forethought Inc. was purchased by Microsoft, who were then introducing a series of products that are today the core of Microsoft Office. Microsoft had introduced its own database application, Microsoft File, shortly before FileMaker but it was outsold by FileMaker and was withdrawn from the market. Microsoft negotiated with Nashoba for the right to publish FileMaker, but Nashoba decided to self-publish “FileMaker 4”.[1] Forethought, Inc. ... Microsoft Corporation, (NASDAQ: MSFT, HKSE: 4338) is a multinational computer technology corporation with global annual revenue of US$44. ... Microsoft Office is an office suite from Microsoft for Microsoft Windows and Apple Mac OS X operating systems. ...


Shortly thereafter, Apple Computer formed Claris, a wholly owned subsidiary, to market software. Within months they had purchased Nashoba to round out their software suite. By that time, Leading Edge and Nutshell had faded from the marketplace because of competition from other DOS and later Windows platform database products. FileMaker, however, continued to succeed on the Macintosh platform. Claris was a computer software company formed as a spin-off from Apple Computer in 1987. ...


Claris changed the name to “FileMaker II” in order to be compatible with the naming of their other products, such as MacWrite II, but the product was changed little from the last Nashoba version. Several seemingly randomly-numbered minor versions followed, when things finally settled down with the release of “FileMaker Pro” 1.0 in 1990. At this point, FileMaker was still a Mac OS–only application.


A significant milestone in FileMaker’s history came with the release in September 1992 of a multi-platform version. Except for few platform-specific functionalities, a “solution” (as FileMaker Pro databases are called) looks and feels the same in Windows as on a Mac. This gave it a very strong position in the marketplace and continues to be one of its key advantages. The following version 3.0, released around 1995, was a significant upgrade with new relational and scripting features. Look and feel refers to design aspects of a graphical user interface - in terms of both colours, shapes, layout, typefaces, etc (the look); and, the behaviour of dynamic elements such as buttons, boxes, and menus (the feel). It is used in reference to both software and websites. ...


By 1995 FileMaker was the only strong-selling product in Claris’s line-up. In 1998, Apple moved development of some of the other Claris products in house, dropped most of the rest, and renamed Claris to “FileMaker, Inc.” to further develop and market FileMaker.


Version 4.0, introduced in 1997, added a plug-in architecture much like Photoshop, which provided for third-party developers to add various non-native functionalities to FileMaker. A bundled plug-in was the Web Companion, which allowed the database to act as a web server; other “plugs” add new features to the interface or allow FileMaker to act as an FTP client, perform external file operations, and send messages to remote FileMaker files over inter- or intra-net. Photoshop redirects here. ...


Since its emergence from the Apple fold, FileMaker Inc. has invested substantially in software development. Version 7 of FileMaker Pro, released in March 2004, supported file sizes of up to 8 terabytes (up from 2 gigabytes in previous versions). Individual fields could hold up to 2 gigabytes (up from 64 kilobytes in previous versions) and FileMaker’s relational model was enriched, offering multiple tables per file and a graphical relationship editor which displayed (and allowed manipulation of) related tables in a form which in some respects resembled the familiar “entity-relationship diagram” format. With this change, FileMaker Inc. also introduced a worldwide developer certification program in recognition of the growing numbers of professional developers working with FileMaker. An Entity-relationship model is a relational schema database modeling method used to model a system and its requirements in a top-down approach. ...


On August 29, 2005, FileMaker Inc. announced the FileMaker 8 product family. is the 241st day of the year (242nd in leap years) in the Gregorian calendar. ... Year 2005 (MMV) was a common year starting on Saturday (link displays full calendar) of the Gregorian calendar. ...


FileMaker 8 offered the developer an expanded feature set. One feature is the tabbed interface, which allows the user to easily create a multi-tabbed layout. Script variables, tooltips, enhanced debug features, custom menus, and the ability to copy and paste entire tables and field definitions, scripts, and script steps within and between files all increase FileMaker's reputation as a rapid development environment.


Version 8.5, released July 10, 2006, added an integrated web viewer (the ability to directly view such things as shipment tracking information from Federal Express and Wikipedia entries) and Named Layout Objects. is the 191st day of the year (192nd in leap years) in the Gregorian calendar. ... Year 2006 (MMVI) was a common year starting on Sunday of the Gregorian calendar. ... Federal Express redirects here. ... Wikipedia (IPA: , or ( ) is a multilingual, web-based, free content encyclopedia project, operated by the Wikimedia Foundation, a non-profit organization. ...


FileMaker 9 was released on July 10, 2007. This update for Windows and Macintosh brought a quick start screen, conditional formatting, hyperlinked pointers into databases, and external SQL links. is the 191st day of the year (192nd in leap years) in the Gregorian calendar. ... Year 2007 (MMVII) is the current year, a common year starting on Monday of the Gregorian calendar and the AD/CE era in the 21st century. ... SQL (IPA: or ) is a computer language designed for the retrieval and management of data in relational database management systems, database schema creation and modification, and database object access control management. ...


Description

A defining characteristic of FileMaker is that the database engine is integrated with the forms (screen, layouts, reports etc) used to access it. Most database systems separate these tasks, concerning themselves primarily with organization and storage of the data.


Until recently, each table of a FileMaker database system was stored as a separate file (with relational links to other files) and each file had its own built-in interface capabilities. Version 7 introduced the capability to build multiple tables into one document. Compared to other RDBMS products, it is fairly easy to develop quickly and to make changes on the fly as the data structure is altered. More complex systems may introduce some separation between interface and data files and FileMaker provides the flexibility to accommodate this. A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd. ...


A substantial body of professional FileMaker developers has grown up around the product and provides the expertise required for complex systems and implementations. A certification program was introduced by FileMaker Inc. in 2004 to provide differentiation of professionals in the field. FileMaker also provides an interface (API) for integration of third-party tools, making it highly extensible. In addition there are a variety of web publishing options suited to both low-end and larger scale project requirements.


Version history

Date Version Published by Comment
Apr. 1985 FileMaker, v1.0 Forethought Inc.
Oct. 1986 FileMaker Plus, v2.1
June 1988 FileMaker 4, v4 Nashoba Systems
Aug. 1988 FileMaker II, v 1.0
July 1989 FileMaker II, version 1.1v2
Oct. 1990 FileMaker Pro 1.0v1 Claris Corporation
Mar. 1991 FileMaker Pro 1.0v2
Apr. 1992 FileMaker Pro 1.0v3
Oct. 1992 FileMaker Pro 2.0v1 First Multi-platform (Macintosh and Windows) version
Nov. 1992 FileMaker Pro 2.0v2
Mar. 1993 FileMaker Pro 2.0v3
Apr. 1993 FileMaker Pro 2.0v4
Aug. 1993 FileMaker Pro 2.1v1
Feb. 1994 FileMaker Pro 2.1v2
July 1994 FileMaker Pro 2.1v3/SDK 2.1
July 1994 FileMaker Pro Server 2.0v
July 1994 FileMaker Pro SDK 2.1v1
Mar. 1995 FileMaker Pro Server 2.1v1
Dec. 1995 FileMaker Pro 3.0v1 Relational architecture, TCP/IP networking introduced
Jan. 1996 FileMaker Pro Server 3.0v1
Jan. 1996 FileMaker Pro 3.0v2
June 1996 FileMaker Pro 3.0v3
June 1996 FileMaker Pro 3.0v4
June 1996 FileMaker Pro SDK 3.0v1
Sep. 1997 FileMaker Pro 4.0v1 Plug-in architecture introduced
May. 1998 FileMaker Pro 4.0 Developer Edition Aimed at expert/professional FileMaker user
June 1999 FileMaker Pro 4.1v2 FileMaker, Inc.
Sep. 1999 FileMaker Pro 5.0v1
Nov. 1999 FileMaker Server 5.0v1
Apr 2001 FileMaker Pro 5.5v1 Built-in support for Mac OS X
July 2001 FileMaker Server 5.5v1
Sep. 2002 FileMaker Pro 6.0v1
Mar. 2004 FileMaker Pro 7.0v1 Multiple tables/file architecture introduced;
multiple windows;
entity relationship diagrams;
calc variables
May 2004 FileMaker Server 7.0v1
May 2004 FileMaker Pro 7.0v2
Sep. 2004 FileMaker Server 7.0v2
Oct. 2004 FileMaker Pro 7.0v3
Aug. 2005 FileMaker Pro 8.0v1 Scriptable creation of PDF reports; script variables
Aug. 2005 FileMaker Pro Advanced 8.0v1
Sep. 2005 FileMaker Server 8.0v1
Dec. 2005 FileMaker Pro 8.0v2
Dec. 2005 FileMaker Pro Advanced 8.0v2
Jan. 2006 FileMaker Server Advanced 8.0v1
Jan. 2006 FileMaker Mobile 8
Apr. 2006 FileMaker Pro 8.0v3
Apr. 2006 FileMaker Pro Advanced 8.0v3
Apr. 2006 FileMaker Server 8.0v3
Apr. 2006 FileMaker Server Advanced 8.0v3
July 2006 FileMaker Pro 8.5v1 Mac OS X Universal Binary Support;
Embedded browser (Web Viewer)
July 2006 FileMaker Pro Advanced 8.5v1 Mac OS X Universal Binary Support
July 2006 FileMaker Server 8.0v4 Mac OS X Universal Binary Support
Mar. 2007 FileMaker Pro Advanced 8.5v2 Windows Vista Support
July 2007 FileMaker 9 Native support for the SQL databases MS SQL, MySQL and Oracle.

FileMaker files are compatible between Mac and Windows. File type extensions are The Internet protocol suite is the set of communications protocols that implement the protocol stack on which the Internet runs. ... Mac OS X (pronounced ) is a line of graphical operating systems developed, marketed, and sold by Apple Inc. ... “PDF” redirects here. ... Windows Vista is a line of graphical operating systems used on personal computers, including home and business desktops, notebook computers, Tablet PCs, and media centers. ... SQL (IPA: or ) is a computer language designed for the retrieval and management of data in relational database management systems, database schema creation and modification, and database object access control management. ...

  • .fm since FileMaker Pro 2.0
  • .fp3 since FileMaker Pro 3.0
  • .fp5 since FileMaker Pro 5.0
  • .fp7 since FileMaker Pro 7.0, up to FileMaker Pro 9.0

Self running applications (runtime, kiosk mode) are platform specific only.


Scripting

FileMaker Pro and FileMaker Pro Advanced allow you to write and edit scripts for automation of common tasks and complex calculations. Over 130 “script steps” are available for navigation, conditional execution of script steps, editing records, controlling windows, finding specific records, checking spelling and managing user accounts. In addition, many of these script steps can use built-in functions for a variety of mathematical calculations, text manipulation and querying your database configuration.


FileMaker and SQL

FileMaker 8 and SQL

Scripts in FileMaker 8 can use SQL to query external databases but a script within a database cannot use SQL to query itself. Finding records in FileMaker tables uses a process like a macro. The script steps allow you to switch between forms, enter search criteria in fields, perform the search, enter more search criteria and further restrict or expand the result set.


FileMaker 9 and SQL

FileMaker 9 includes the ability to connect directly to a number of SQL databases, including MySQL, SQL Server, and Oracle. This requires installation of the SQL database ODBC driver and configuration of said ODBC driver (using the operating system’s ODBC manager) to connect to a SQL database. Once this is complete, SQL databases can then be used as data sources in FileMaker’s relationship graph, thus allowing the developer to create new layouts based on the SQL database; create, edit, and delete SQL records via FileMaker layouts and functions; and reference SQL fields in FileMaker calculations and script steps.


References

  • Dancing-Data, detailed history from 1980 to 1989

External links

  • FileMaker Inc. website, including Technical Knowledge Base
  • FileMaker Developers in Southern California (FMDiSC), including online group and monthly meetings
  • New York Filemaker Developers's Group, including online group and Wiki
  • FileMaker Pro User's Group, International, Monthly meetings, Specials, Discounts, Reviews, Support

  Results from FactBites:
 
ISO FileMaker Magazine (2060 words)
FileMaker had to establish some type of method for acting on the data - they chose context.
While FileMaker lacks an extensive event based user interface, it is possible to trigger scripts based on a variety of situations.
When I first started using FileMaker and getting involved in the community, I thought it was the cat's meow to be able to have access to beta versions.
FileMaker - Wikipedia, the free encyclopedia (1160 words)
FileMaker Pro is a cross-platform database application from FileMaker Inc. (a subsidiary of Apple Computer), known for its combination of power and ease of use.
FileMaker was one of a handful of database applications released on the Apple Macintosh in the 1980s.
FileMaker is now available for the Macintosh and Microsoft Windows operating systems, and can be networked simultaneously to a mixed Windows and Macintosh user base.
  More results at FactBites »


 

COMMENTARY     


Share your thoughts, questions and commentary here
Your name
Your comments
Please enter the 5-letter protection code

Want to know more?
Search encyclopedia, statistics and forums:

 


Lesson Plans | Student Area | Student FAQ | Reviews | Press Releases |  Feeds | Contact
The Wikipedia article included on this page is licensed under the GFDL.
Images may be subject to relevant owners' copyright.
All other elements are (c) copyright NationMaster.com 2003-5. All Rights Reserved.
Usage implies agreement with terms.