AnsweredAssumed Answered

Get Count and the Data from ExecuteSQL command

Question asked by Stu412 on Jul 18, 2016
Latest reply on Jul 18, 2016 by Johan Hedman

Hi there

 

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.

Outcomes