Database

Date and time functions

Nerd alert, not for all audiences Hi We have reworked all the date, time and related functions inside the database to make use of the

Read More »

Timetraveling for Power-Bi

Spoiler alert: Nerd-article The SMS-Timing software is more and more used as a single tool to run an entire business or family entertainment center.  Also

Read More »

Translate states to readable names

When extending the software with custom queries or reports, it is sometimes needed to translate values in the database to readable states. The query below

Read More »

Performance and settings

To keep our database nice and tidy, following helper methods are added Increase performance during batch operations SYS_CTX_UPDATE allows you to change the state of

Read More »

Transactional Stock

In the upcoming version 6.20.03.09 the stock management back-end is completely rewritten. The engine is switched to a transactional engine. The new engine stores each

Read More »
en English
X