I have a portal in FileMaker 13 and would like to transfer its data to an SQL table using ODBC.
I have the following script, it does work but only for the first record, it does not go to th next records in the portal.
I have passed the values of the Portal as Parameters in the script (List(SelectedCustomProperties::CustomPropertyId;SelectedCustomProperties::CustomPropertyName;SelectedCustomProperties::CustomPropertyDescription)
Go to Object [Object Name: "SendToSQL"]
Go to Portal Row [Select;First]
Go to Layout["SQLTable Layout"] -> this layout is actually the table from SQL but coonected through ODBC
Go to Portal Row [Select;Next;Exit after last]
Am I missing anything?
Your help is much appreciated.