This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
custom_checkin [2017/09/12 12:48] kristof |
— (current) | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ===== Configuration ===== | ||
| - | Vul een SQL Server functienaam in de tabel General.StClientDisplay | ||
| - | |||
| - | * Veld: **checkin_function** | ||
| - | * Waarde (bvb): **dbo.F_DOORACCESS** | ||
| - | |||
| - | Vb van functie: | ||
| - | // | ||
| - | CREATE FUNCTION [dbo].[F_DOORACCESS](@member_id int) | ||
| - | RETURNS nvarchar(50) | ||
| - | AS | ||
| - | BEGIN | ||
| - | return 'Geen toegang' | ||
| - | END// | ||
| - | |||
| - | |||
| - | ===== Return types ===== | ||
| - | Er zijn 5 verschillende returns: | ||
| - | |||
| - | * " | ||
| - | * " | ||
| - | * " | ||
| - | * " | ||
| - | * plain tekst: | ||