SQL Archives - CE-iT

Using variables in MA!N functions

ceit-beheer — Thu, 08 Feb 2024 12:14:06 +0000

Some MA!N core functions offer variables to address the information needed. During the processing of these functions, MA!N replaces the variables with the right information.

The post Using variables in MA!N functions appeared first on CE-iT.

Linking files with SQL to items in MA!N

ceit-beheer — Wed, 14 Dec 2022 13:36:37 +0000

You can easily let people open files from MA!N just by adding a simple SQL command. Whether it concerns a sent letter or files in a situation where MA!N functions as a document management system.

The post Linking files with SQL to items in MA!N appeared first on CE-iT.

Creating a compressed back-up of a database

ceit-beheer — Mon, 15 Nov 2021 08:23:00 +0000

A script for creating a compressed and encryted backup with integrated back-up the functionality of SQL.

The post Creating a compressed back-up of a database appeared first on CE-iT.

Using color in a datagrid

ceit-beheer — Wed, 11 Aug 2021 13:15:00 +0000

It is possible to give a row in a datagrid a different color based on the contents of a column that row.

The post Using color in a datagrid appeared first on CE-iT.

SQL dependency in MAIN

ceit-beheer — Tue, 09 Feb 2021 13:10:04 +0000

Sometimes you want database changes pushed to a screen without interaction of the user. This requires a few updates to your database.

The post SQL dependency in MAIN appeared first on CE-iT.