Information can be retrieved without creating any kind of relationship. This reduces complexity and allows users to pull data independently of the layout. The function also means data queries can be made even when there is no specific layout. Previously, developers used plugins to expose the SQL underpinnings of FileMaker. The ExecuteSQL calculation function simplified the process by making it possible for users to perform many tasks without accessing the Relationship Graph. These statements allow you to create and modify tables and indexes. SQL also provides statements for performing data definition. In addition to language for querying a database, SQL provides statements for performing data manipulation, which allow you to add, update, and delete data. It is a cross-platform relational database application. SQL databases can 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. It is widely used in most other database platforms and is completely text based. However, it is not done with a visual reputation of a database like using a relationship graph. It is a process that allows databases to perform a "Find Request" as Filemaker developers call it.
FileMaker Pro is powerful, easy-to-use database software that helps you and your team get any task done faster. Database management for iPad, iPhone, Windows, Mac and the web. SQL has been a part of FileMaker since version nine. To sum it up, FileMaker Pro Advanced is a must-have tool for creating custom apps that work. FileMaker 13 has improved the tool with increased functionality.įirst off, it is important to note a few things. With the help of a FileMaker developer, any organization will be able to gain a hand adopting the latest version of the database program.One of the most talked about features of FileMaker 12 when it launched in April 2012 was the inclusion of the ExecuteSQL (Structured Query Language). One connection comes packed with the server at the time of purchase and can be purchased in groups of 5 up to 50 connections, which the service was tested for to ensure proper support. Through this solution, companies also gain access to other features that include: desktop-style interaction with themes, styles, charts, menus and even the ability to drag and drop files into container field, real-time updates to data without refreshing the browser and automated processes that enable scripts, calculations and conditional formatting to validate data and streamline workflow.įileMaker WebDirect can also be accessed through concurrent connections in FileMaker Server 13. All you need are the existing FileMaker skills to create access to your database through a web browser with just a few clicks. So if you are a business looking to create robust web content, you no longer need to be familiar with custom coding tools like PHP, HTML5, CSS or JavaScript.
One of the most intriguing is FileMaker WebDirect.Īccording to the company, WebDirect is a "breakthrough for web technology that runs custom business solutions directly in a web browser on a desktop or laptop." This is done without the requirement of web development skills and offers a full blown FileMaker experience. It improved on the older model in several different ways, while also introducing a number of new features.
In December of last year, FileMaker introduced version 13 for iOS 7 and Mac OS X Mavericks.