Hi Everyone, I am integrating MS RMS with another product using a DLL. I want to store some of my details in the RMS database (very small text messages like TRANSACTION SUCCESSFUL, FAILURE, INTERRUPTED) for Reports and future references... I'll be very thankful if someone can help me on how to connect to the RMS database and how to store the messages in the database for Reports and Reconcilations... Thank you very much...
Sri....
Hi Antonio, SQL Server is the only DBMS I know to some extent and I don't have a documentation for RMS database, if you can help me, I'll be very thankful, Thank you... Srikanth....
If you're using Visual Studio or Visual Basic 6 to build your integration, Use the Object Browser to examine QSRules
SessionClass.Database returns a Gateway object
Gateway has various methods that perform specific queries or updates on the database. It also has a couple of methods that allow you to specify a SQL string or Stored Procedure to perform.
You need to create a new table in the RMS database to hold your extended data. - include the TransactionNumber to link it back to the [Transaction] table.
Good Luck.
You can create a custom-table with SQL statement.. and a custom-report.
Do you have documentation of RMS database? or experience with SQL Server?
Antonio
Srikanth wrote: I want to store some of my details in the RMS database (very small text messages like TRANSACTION SUCCESSFUL, FAILURE, INTERRUPTED)
? Yes.. and to store into database text messages you must know the SQL and the RMS database schema..
Now I'm on holidays.. and I have no more time to send you documents. Do you have access to customer source or partner source on mbs web? or go on
Have something to add? Share your thoughts — no account required.
Ask the community — no account required