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
Why don't you use substitute and get rid of the illegal characters?