|
Posted by Glenn Adams [MVP - Retail Mgmt on August 8, 2005, 8:40 am
Please log in for more thread options
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.
--
Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information
> 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....
>
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap