Enum mismatch issue

lxia

I'm adding a bunch of records into a DB table using a loop. One of the fields is an enum type and occasionally the value being passed in does not match the enum.

e.g. enum = Apple, Pear. however the value = Watermelon.

Adding a null value into the enum field when this happens is an acceptable outcome.

Any suggestions?

Michael Udinski

@lxia - this sounds like a scenario for a Try/Catch where in the catch you can update the value of your enum field to null if it throws an exception for not being an allowable value

lxia

Looks like the right solution. Will give it a go. Thanks for the prompt support Michael!