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.
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
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.