Import records problem....

[Cabinetman]

I guess I just can't see it.........but there's a oops somewhere in here.

I'm getting a "yes" in every record sometimes showing as updated=yes even though the import file was empty.

some lines are abbreviated......

Import Records [ Source: “file:update.txt”....Method: Update matching]

Set Field [ table::gErrorCode; Get (LastError) ]

If [ Get(FoundCount) = 0 ]

   Show Custom Dialog [ Title: .....]

   Set Field [ table::number of import errors; 1 + table::number of import errors ]

   Show All Records

   Go to Layout [ “whatever” (layout) ]

   Exit Script [ ]

Else If [ table::ErrorCode = 409 ]

   Show Custom Dialog [ Title: ......... ]

   Set Field [ table::.....]

   Show All Records

   Go to Layout [ “whatever” (layout) ]

   Exit Script [ ]

Else

   Replace Field Contents [ table::updated; Replace...tion: "Yes" ]

   Set Field [ table::records updated; Get(FoundCount) ]

End If

[Fitch]

It would appear that the found count after import is not zero, and the last error was not 409, so it's proceeding to the Replace step. Do you have FM Advanced so you can step through with the script debugger?

[Cabinetman]

Yes and ran it.... no errors this time and not sure what caused it as there's more to the script and several fields are modified.

I have set it to 'pause on error' hoping to catch the problem..........