Once you have your query perfected in RazorSQL, you can then build it in FileMaker, knowing that you have the basic query correct. With regard to the last issue, RazorSQL is a nice tool for working directly with your FileMaker solution to very quickly test SQL code. On the down side, you have to be very careful about its impact on your application’s performance and building SQL queries in FileMaker’s calculation dialog is challenging. It can help keep your relationship graph simpler, allow you to query data without changing your context, and makes virtual lists easier to build among other things. The advantages and disadvantages of SQL in FileMaker are pretty well known.
In the early days it required a 3rd party plugin, but since version 12 we’ve been able to run SQL Select statements against our FileMaker data with the native Execute SQL function. Developer’s have been able to run SQL queries against their FileMaker data for many years.
0 kommentar(er)
