I’m looking for a more elegant way of doing a recipe change.
[li] -Check for change to Status field in DB to indicate a changing recipe.[/li]
[li] -Write to Status field to indicate a recipe change in progress.[/li]
[li] -Update recipe values using from database.[/li]
[li] -Write to Status field to indicate the recipe change has completed.[/li][/ul]
I’ve had to toss out stored procedures due lack of support in the legacy database, and I can’t change the database schema as the recipe generation is handled by an existing application (hence the handshaking).
I’m currently planning on scripting this, but transaction groups seem like they might be viable alternative. Any ideas?