There are a few optimisation strategies for Case. At a simple level consider the Let statement…
Let([
f1 = field1;
f2 = field2
];
Case (
f1 = 0 and f2 = 0 ; <result1> ;
f1 = 0 and f2 = 1 ; <result2> ;
f1 = 1 and f2 = 0 ; <result3> ;
f1 = 1 and f2 = 1 ; <result4> ;
<default result> )
)
We are pleased to announce that one of our Senior FileMaker Developers has just passed the Oracle MySQL Developers exam with flying colours.
Today, FileMaker announced the full schedule for the FileMaker Developer Conference 2011.
Filemaker’s ability to connect to any of the major SQL databases without having to do any SQL is a real killer feature but performance can often not be what it might. Often this is caused by Filemaker having to hammer the SQL data source. There are a few tricks that can move a lot of the work onto the SQL side.
We have all been busy here at Linear Blue helping to save the world! In case you didn’t already know, we have created the Linear Green strategy to try and do our part as a business and cut our carbon footprint. At first we weren’t too sure how effective the campaign would become, however, we are pleased to say all staff at Linear Blue jumped on the Linear Green mission and the outcome has been fantastic.
The Futures Company have recently undertook a study looking at the characteristics of a leading brand.
It’s getting cold again now. I know that because my heating bill has gone through the roof and my car needs about half an hour each morning before I can see through the windscreen. It’s also dark all the time. I leave my house when it’s dark and I get home when it’s dark. I don’t suffer from SAD though… People tell me I’m grumpy all year round… Which is nice.
Integrating your FileMaker database with a third party system can be complex and painful. However if they publish a WSDL (Web Services Description Language) then things become a lot easier. The integration is basically a two way conversation using XML, and is made very easy with the Web Services Plugin from Beezwax.
We have been in discussions recently about measuring our customer service. We measure many key areas across the business, such as, response times and project success rates. This ensures efficiency is consistent across the board, but we want to know what our clients think about client service.
Recently we have been working on a system that requires a large amount of data to be synchronized to MySQL (for driving a web interface) from FileMaker. After a few initial tests of methods for achieving this we found that the speed of the transfer was un-acceptable due to the large amount of data being transferred. The transfer was set to take place at several points throughout the day and would often still be running when it needed to run again – not good.
