Apple Training package: Virtual List and ExecuteSQL Activity Not Working

In an old training package based on FM 15, there's a step by step activity with a solution file to play with.

At step 7, the global is not even created, not seen in the DataViewer's watch while $$ArrayBlaBla is. What's the problem? Do I have to separate out anything with & in the calculation?

Here's the solution file:

06b_Bonsai WorkInProgress.fmp12 (5.8 MB)


The query is looking for records with DateOrdered between 01 Jan 2021 and 24 Mar 2021.
Does any of the records meet the criteria?

1 Like

The calculation contains no syntax error, otherwise you would have a global variable with the value "?" (no quotes). Therefore, the SQL statement returned nothing, meaning no record satisfied the query.

1 Like

Forgot to say… welcome to the soup "Gaston".


Success! Replaced the first argument with a hard-coded 1999.

Thank you Torsten and bdbd!

I should have seen that but the activities beforehand have been so flawless, easy to use. Looking at the code and tables, I had presumed a grave error or ignorance of Filemaker on my part yet the error lied in assuming users of the training package would use it the same year the package was created. But I still feel stupid. lol :slight_smile: Should have looked at the data.

1 Like

Great that you got it working. Welcome to fmsoup @backagain!

It happens to us all, having the thing right before our eyes and yet we don't recognise it. Two pairs of eyes see more than one pair of eyes... That second pair of eyes can be a fellow developer here @ fmsoup :slight_smile:

1 Like

Welcome to the soup @backagain . Be warned that there are some errors in the FileMaker Training series. It is an excellent resource but a couple of errors slipped past the editors. You may bump into something else that doesn't look right.

Yes, I found another bothersome error in the same activity. Posting soon.
Thanks for the warning.
Are there better beginner/intermediate training resources you know of? (so that I don't feel like deleting Filemaker off my drive while shouting every profane expletive I know)

I'd been going through Richard Carlton's Udemy courses but I was guided by a pro to this old FM 15 series as superior and complete.

The explanations are certainly good. This is the first example that doesn't work for me. Maybe someone like me just needs to make an accompanying errata sheet and post it on this site along with the course material. :slightly_smiling_face:

1 Like

I think it is an excellent resource. It is comprehensive and the examples are excellent. They have practical applications and they introduce fundamental concepts in a sensible way.

1 Like

My layout only updates the record when I edit/update the row number.

If the calculation is unstored, this should not happen. But I cannot find the option which used to look like this "Do not store calculated results":


Can't find it:

You are using an auto-enter calculation on a text field. Try it with a calculation field.

1 Like

Yep. That was it.
Should have been written:
Create a new calculation field, or field of "type:" Calculation, with the option Calculation result is: Text.

Much thanks Malcolm