AnsweredAssumed Answered

Skipping ODBC error

Question asked by sherry199559 on Mar 14, 2018
Latest reply on Mar 15, 2018 by beverly

Hi.

I'm trying to import filmmaker data into a mysql table using. But I get ODBC error when there is special character in the Description field. I want to skip this error and delete this record and continue import the next one. Not sure what script steps I can use.

Here is my script steps, any help would be appreciated!

 

Set Error Capture [On]

Loop

   Set Variable [$$ITEMID; Value: Invoices::ID]

   Set Variable [$$DESC; Value: Invoices::Description]

   ........

   Go to Layout ["Sold Items"]

    New Record/Request

    Set Field [SoldItems::idSoldItems; $$ITEMID]

    Set Field [SoldItems::Desc; $$DESC]

    Go to Layout [Invoices]

    Go to Record/Request/Page [Next; Exit after last]

End Loop

Outcomes