Not sure if this is possible to work in the way I'm thinking. I need to select some data as a virtual list and then split it out as described in the Filemaker training series manual (advaced) 2013, which is a routine I've used previously to good effect.
I'm wondering if there's a way you can tailor the rows created on the destination table to be equal to the number of results you've gathered from the ExectureSQL command? The training series points towards a set number of rows. I'm using a simple piece of code to start with just to test it out:
ExecuteSQL ( "
Select ''|| CustID_FK, P1Perc from Warehouse
where P1Perc is not null
Order by CustID_FK
As you can see, this is pulling from a warehouse which is always flexing with regard to the amount of available data, so to have a static table length as per the training series manual puts a limit on things which I want to future proof.
I'm thinking about placing the (SQL) foundcount result into a variable and looping up the required empty records from there. The table with the new records will be used for charting later on and then dropped until required again.
Any help greatly appreciated, thanks in advance.
ExecuteSQL is perfect to catch some data out of a non related table. If you like to create certain data into a Virtual List to show in Dashboard or Chart instead create a Perform Script on Server that creates the records that you want