Anyone help me on steps to connecting with MS SQL Server 2005 and insert/update with the values from RMA screen
The short answer is that you can't. After trying many different tactics, it just can't be done from the standard providers or custom providers. When I got serious with trying to make it work, I examined carefully all the methods that are available to a provider both in the documentation and looking at the code, and it is just not possible. There is no entry method that is called at the time it would make sense to insert or update a database. The one last tactic I was going to try was to use the custom BOMA. But that is a much larger effort than I have had time to pursue.
In my last project when we needed to do some optimizing, what we ended up doing was breaking it into two Blaze Projects. One had the items we wanted to reference from the database and the other that does the refering. Then, a button was added to the RMA that would do a precompile of the project. The second project was deployed using the deployment manager that watched for the first to be precompiled. Finally, a listener was added to the deployment manager. When the final event (I believe it was reset) was detected, a Method in the first project was called to populate the database.
Hope this helps,
What I did in a similar situation was to create a template that contained an iframe. In the iframe, I included a simple web interface that did the insert/update-operations based on an ID that I retrieved using a custom provider. I sent the ID to the external application by passing it as a template argument to the template that contained the iframe, and I embedded the ID in the iframe URL.
That way, the rules knew the ID, and all the operations were in the context of that known ID.
If you need to provide some of those values to the rules source, you do that using custom providers, which query the DB using the known ID.
Tas: I don't think a custom BOMA is going to help you there. There are no perfect points at which to do the insert/update there either.
If you do need a custom BOM (that is, an object model that is not based on standard Java/C#/database tables/an XSD), I tried to create a wrapper library that is/should be easier to use a couple of years ago. Instead of all the Nd* classes, it is based on implementing a handful of interfaces and should therefore be easier to test with regards to the rest of your code. I created a couple of BOM implementations based on it, just to prove it could work, and those didn't take that long...
It's not too polished, but it could be a starting point if you do need that kind of functionality...
could you please elaborate a bit on this?
Retrieving data ...