Archive

Archive for the ‘Database’ Category

FileMaker goes to 11!

March 9th, 2010
So we’ve now got a new version of FileMaker . It’s got improvements across the board which make it a better, more productive development environment. There are no dramatic surprises as FileMaker has kept up their mantra of slow and steady improvement in the product. Many of the changes appear to be small, but smooth away the rough edges. The .fp7 file format has been maintained, so no conversion process is required to use an existing post-FileMaker 7 solution.

Read more…

Ian Jempson Database, FileMaker

ESS, MySQL, views and temporary tables

December 14th, 2009

I am continuing to work on an ESS integration project and one of the biggest issues is speed when dealing with large record sets from MySQL.

Read more…

Damian Kelly Database, FileMaker, Web , ,

Important information on Server based imports and exports

November 9th, 2009

Automated server based scripts for Importing or Exporting are a great way of moving time consuming jobs away from users. Whether it is exporting a report from a complex find or generating records overnight to save the users time during the day, there are two very important things to remember.

Read more…

Simon Ward Database, FileMaker, Linear Blue

ESS and Surprised MySQL developers

October 27th, 2009

I had a conference call with a client, one of their biggest customers and the customers’ developers the other day. Both the customer and my client are having new systems written (my client in FileMaker, my client’s customer in MySQL and, i guess, HTML) and they are both keen on integrating stock figures.

Read more…

Damian Kelly Database, FileMaker, Web , , , ,

Digital Pen and Paper Technology

October 23rd, 2009

I have been doing quite a bit of work with smart pens recently so I thought I would drop in a quick primer on the technology.

Read more…

Damian Kelly Business, Database, FileMaker , , , , , ,

SQL Joins

October 21st, 2009

When writing a PHP based site – developers often also have to integrate with a database (otherwise the site tends not to be very exciting!) and a popular technology for this is a flavour of SQL. Rather than go through the basics of database queries using SQL (which if enough people ask me for – I certainly will do in the future) I have decided to write specifically about the mechanics of the JOIN command. The SQL Join command allows us to pull and combine data from two or more tables, where the result can be modified by specifying different data relationships between the tables.

Read more…

Rob Basden Database, Web ,

How to avoid script triggers ruining your day

October 19th, 2009

Script triggers are your best friend and worst enemy. They are great when they trigger as required but not always so good when you don’t want the scripts to run.

Read more…

Simon Ward Database, FileMaker

Finds Across multiple windows

July 6th, 2009

I was thinking how useful it would be for a user working in a FileMaker database to be able to filter a list in their current window based on content from another window, FileMaker 10 script triggers now makes this possible.

Read more…

Paul de Hallé Database, FileMaker ,

Why FileMaker? Pt.4

June 22nd, 2009

I’ve been working with FileMaker for over 20 years and the question that always arises is ‘Why do you use FileMaker?’ or ‘Is FileMaker the right platform to develop our database on?’.

Read more…

Paul de Hallé Business, Database, FileMaker, Linear Blue

Why FileMaker? Pt.3

May 18th, 2009

I’ve been working with FileMaker for over 20 years and the question that always arises is ‘Why do you use FileMaker?’ or ‘Is FileMaker the right platform to develop our database on?’.

Read more…

Paul de Hallé Business, Database, FileMaker, Linear Blue , , ,