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 »

Advanced user queries

The fast software already supports custom queries since the very beginning. Although this allowed us to greatly extend the functionality of the ecosystem, it was

Read More »

Country sensitive formatting of addresses

Starting of version 6.20.01.24 both database and client format street and city depending on the country. Country sensitive formatting is also supported for custom databasequeries

Read More »