However, as this is all handled by our script, you do not need to know SQL to use this solution. The real trick is dynamically building the SQL we want to use. Once we have a list of IDs, we can enter those in a global field, where it will act as a multi-key relationship to show related records in a portal. The script will then perform an ExecuteSQL to build a list of IDs that relate to the table we want to show results from. In this example, we will attach a script trigger to a global field that will fire on every keystroke. This post will detail and explain yet another technique of the ExecuteSQL function – Search as You Type. There have been many useful techniques that have been demonstrated since its introduction. It allows you to construct relationships in SQL that do not necessarily exist in your application otherwise. Using SQL, SELECTS on indexed data is blazing fast and efficient. SQL (Structured Query Language) is a standard used with other, more traditional, database servers. First introduced in FileMaker 12, it allows you to perform “select” queries against your FileMaker data, as opposed to the more familiar “Find” functionality available in FileMaker. FileMaker introduced a very different kind of capability with the ExecuteSQL function.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |