Subtitles of the Movie

There're also some other great advanced developer features that allow you to customize the solution. For instance, you have Custom Functions. These allow you to take a formula that you might be using a lot throughout your solution, and rather than having the code in this calculation field, in this table, and in another calculation field, and another table, and maybe using a script as well, you can centralize it all inside of a Custom Function and call it inside of that calculation or script. So what that allows you to do is update that Custom Function, and when you update that Custom Function, it flows through to whatever you call it, so you can call it with a very easy syntax and it all goes back to a central location. So Custom Functions are just wonderful as far as taking code to use over and over again, in other words, reusing code. Custom Menus is another great feature where you can take the menus and modify them however you want. Change the keyboard commands, remove a menu item, even have it run a script or even add a menu item of your own choosing. Both Custom Functions and Custom Menus allow you to add it in FileMaker Pro 9 Advanced, but these two features are still available to people using your solution who don't have Advanced. In other words if you create them in Advanced you can edit them there, but that doesn't mean they go away in the regular FileMaker Pro. They're still there, they just can't edit them with FileMaker Pro. And, then another one of my favorite features is copy and pasting in schema. Schema means fields, scripts, script steps, tables, in other words, you can copy and paste these to other places. Like I might want to take this field, copy it, and then paste it into another table because I need the same field. Imagine how much time that can save you, and I'll use that quite a bit during this tutorial as we get into using the solution. So, FileMaker Pro 9 Advanced is a very handy tool. It's not required, but it is very handy. And here we have FileMaker Mobile 8. Basically it allows two-way synchronization with Pommel S and pocket PC hand-held devices. In other words, you can take your hand-held device out, make some entries into a FileMaker database, although a limited version of it, and then bring it back and synchronize it with your FileMaker. So, it's very handy for taking your FileMaker out on the road, and coming back and synchronizing with it. FileMaker Server 9 is basically a high performance server software for large teams of FileMaker users. In fact, you can get 250 people on a local area network connecting to the same database. It maximizes the performance and the security for large groups, so remember FileMaker Pro only could support five people, FileMaker Server 9 can support up to 250 people, so quite a big difference. Plus, it's going to do it much faster. The performance has, as, is really been tweaked in this version, so it's much better. You also get great tools for backups and other administrative tasks. Now here's some differences in FileMaker Server 9 versus what we're going to talk about FileMaker Server 9 Advanced, versus what was available in FileMaker Server 8 and 8 Advanced. So if you look down here, FileMaker Server 9 now supports XML, XSLT for custom Web publishing. Before that it was only available in FileMaker Server 8 Advanced. It's now been moved down to the regular server version. The new PHP feature for custom Web publishing is also available in FileMaker Server 9, and the new ESS or External SQO data source feature which allows you to connect up and put tables from SQL data sources right inside of FileMaker and put fields on there and make calculations based on this really cool, great new feature, which is different really from the ODBC feature from before. This is actually supported by FileMaker Server 9 and is different than the ODBC, JDBC feature that was in FileMaker Server 8 Advanced before. So that supported all these things in the regular version. So what is FileMaker Server 9 Advanced? Give you. Well, all the features you just saw in FileMaker Server 9, plus it supports ODBC and JDBC data sources. This is how it worked before, you know, going ahead and connecting up to any ODBC data source is what it can do. It's different than the ESSS feature, and its the only way to support instant Web publishing, so you need that. So it is not a big giant different, but if you need either of these two features, the ODBC, JDBC data source feature, or in some Web posting, you have to have FileMaker Server 9 Advanced.