Capturing Imported record count variable
FMP reports the number of records imported when it completes an import. Can this variable be captured in a script? I could not find a script function that grabbed this variable within FMP. Thanks.
When records are imported, the current found set are the records that are imported. Import the records, set a global field or variable to the Get ( Found Count).
Thanks, but that is actually what I am trying to work around. It is particularly problematic when no records are imported and if course FM simply would report the previous count of records being browsed as nothing has changed. While I can script around this, I was hoping I could simply capture the variable from FM.
I would expect that no records imported will return an error.
Experiment and see if you can use Get ( LastError ) to detect when no records were imported.
Either that, or you can use Set FIeld [ $OriginalCount ; Get ( TotalRecordCount ) ] to record how many records were present in the table before importing and then you can compare the value of $OriginalCount to Get ( TotalRecordCOunt ) after the import to get the number of imported records.
Thanks Phil. We do some complicated import schemes based n found records and I was trying to avoid programming a pre and post record count comparison for all the various files. Interestingly, in the Script Debugger no error results are reported when no records are imported, but I will dig deeper in the FMP error codes to see if there is one.
Retrieving data ...