I'm creating an app where i need to get some information based on search criteria and based on the result create some records for each result.
ExecuteSQL("select city, count(customerID) from customers group by city" ;"";"")
this results in a field that has something like
Now for each of these result rows i want to create a record in a summary table
so i need to loop through the result rows.
How can i do that in a FM Pro script.
In regular SQL this would be something like 'INSERT INTO summary SELECT city, COUNT(customerID) FROM customers GROUP BY city'
But how do you do this in FMPro.