Is it possible to update records in the RMS database using SQL statements that are coming from an external source (ie. other programs that are connected via ODBC) with out crashing POS terminals? We want to add order records and update fields for records in the customer table using custom internal software.
Updating RMS database with out crashing system
Jul 05, 2006
1 Replies
RMS is based on MS SQL Server. SQL Server is quite capable of servicing multiple applications. The only thing that's likely to crash RMS is a lock on a row or table that RMS is trying to use. As long as your application is well behaved, you should be fine.
DON'T ALTER any tables. DON'T use Identity Insert. If you use Transactions, make sure you commit or rollback as soon as possible.
Glenn Adams Tiber Creek C> Is it possible to update records in the RMS database using SQL statements
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required