Use SSMS or create a DB Task…
Create a file that contains the script, and save it as [CBL]Update Menu Button Prices.sql in:
[Docmuents]\SambaPOS5\Database Tasks\
NOTE: FYI, the
[CBL]prefix on the file name is optional, but they are “flags” that indicate what is supposed to happen when the Task is executed:
- C = Prompt for Confirm before execution
- B = Backup DB before execution
- L = Logout (and since you are altering the DB, a logout is required to refresh the Cache)
Run the Task in Manage > Settings > Database Tools > Database Tasks …
Or use the Execute Database Task action and attach it to an Automation Command …
