Hi all,
I'm writing a program accessing RMS through QSrules. So far I'm having some success reading data etc. However, I want to add items, cashiers, etc. Is there any way to do this without accessing the SQL database directly? I wanted to avoid direct access if possible.
Ta, Mike
QSRules has methods to execute SQL Commands. They are part of the Gateway class, and IIRC they are accessed through Session.Database
There is one that returns a record and another that executes a command. The advantage to using these methods is that they use the database connection established by RMS, so you don't have to manage your own connection string. The downside is that they aren't exactly using what would be considered best practices for data access.
Have something to add? Share your thoughts — no account required.
Ask the community — no account required