November 1, 201114 yr I am importing and updating mutilple records based on "Matching" an UID. Was trying to stay away from creating an additional import table. Was wondering if there is a way to identify when a matching record is not found. Tried setting error code on, but get no error whether the matching record is found or not.
November 1, 201114 yr Found set will be empty if no records match (unless the "add new records option) is selected and new records are imported. Not sure why the error code is not working: it should.
November 1, 201114 yr Author That made sense.. but I am getting Get (LastError) =0, Get (FoundCount)=0 whether there is a match or not.. Running the import in a loop.. #IMPORT RECORDS Set Error Capture [On] Import Records [No dialog; $path; Client_Import.xsl; Update matching; Windows ANSI] #Check for Matching Company ID Show Custom Dialog ["Error"; Get (lastError) & Get (FoundCount)] If [Get (FoundCount)=0] etc...
November 3, 201114 yr Author Found the issue, like I said, was using a loop and forgot to include a "Show All Records" before the import.. because after the first one.. it would only have that single record. Thanks Vaughan.
Create an account or sign in to comment