| Název | Popis | Datový typ |
|---|---|---|
| AShortDescription | VarChar(200) | |
| AProblemDescription | TextBlob(0) | |
| AProblemData | TextBlob(0) | |
| AImplementationData | TextBlob(0) | |
| ASite |
begin
select AOID from GenerateOID('05AXCRARHBEL3C5V00CA141B44', '01') into mOID;
mToday = current_date - cast('31.12.1899' as date) + 1;
mKind = 1;
mEntryNumber = 0;
select
coalesce(Max(EntryNumber), 0)
from
SystemSupportBook
where
(Firm_ID is null) and (EntrySite = '01') and (Kind = :mKind) into :mEntryNumber;
mEntryNumber = mEntryNumber + 1;
INSERT INTO SystemSupportBook (ID,
Kind,
EntryDate$DATE,
CreatedBy_ID,
NotifyOnStart,
NotifyOnSite,
EntrySite,
EntryNumber,
ShortDescription,
ProblemDescription,
ProblemData,
ImplementationData) VALUES
(:mOID,
:mKind,
:mToday,
'SUPER00000',
'A',
'01',
'01',
:mEntryNumber,
:AShortDescription,
:AProblemDescription,
:AProblemData,
:AImplementationData
);
end;Generated by ABRA Software a.s. 27.10.2021 16:34:16