Subtitles of the Movie

There's also some other great advance developer features that allow you customize a 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 the 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 wherever 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 in there but that doesn't mean they go away in the regular FileMaker Pro. There are still there. They just can't edit them with FileMaker Pro. And then, another one of my favorite features is copy-and-paste the schema. Schema means field, 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 PALM OS and Pocket PC handheld devices. In other words you can take your handheld 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 Sever 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 can 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 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 was only available in FileMaker Server 8 Advanced. It's now been moved down to the regular server version. The new PHP features for custom web publishing is also available in FileMaker Server 9. And the new ESS or External SQL 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 than the ODBC feature from before. This is actually supported by FileMaker Server 9. It is different than the ODBC, JDBC feature that was in FileMaker Sever 8 Advanced before. So that's supported, all these things in the regular version. So what does 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 ESS feature and it's the only way to support instant web publishing. So you need that. So there's not a big, giant difference but if you need either of these two features the ODBC, JDBC data source feature or instant web publishing you have to have to have FileMaker Server 9 Advanced.