I have a named query to delete a record giving a parameter. the script runs no errors but does not delete the record on the database side. When using the named query testing tool it works fine but not through scripting. The query type is changed to update as a select would cause an error. Am I missing something?
The parameter spelling in the Named Query definition and the parameter spelling used in the script are not aligned.
Thank you so much. A little embarrassing that I didn't catch that but glad you did.