meta data for this page
IBExpert "Text to insert" form default block
execute ibeblock (
StatementID variant,
SelectedNames variant,
SelectedNamesFmt variant,
SelectedTypes variant,
ParentName variant = '',
ParentNameFmt variant = '',
ParentType variant,
--------------------------------
ObjectAlias variant = '',
VarPrefix variant = '',
InsertCRLF Boolean = FALSE)
RETURNS (
StatementCaptions variant,
StatementText variant = '',
DoNotFormat Boolean = FALSE comment 'If TRUE, no additional formatting will be performed')
as
begin
-- Uncomment following line to avoid additional formatting of statement text
DoNotFormat = TRUE;
CRLF = ibec_CRLF();
if (StatementID is null) then
begin
if (SelectedTypes[0] = __dboDomain) then
begin
StatementCaptions[101] = 'Drop domain(s)';
StatementCaptions[102] = 'Set description (direct UPDATE)';
StatementCaptions[103] = 'Set description (COMMENT ON)';
end;
else if (SelectedTypes[0] = __dboTable) then
begin
StatementCaptions[201] = 'Block Example AVX';
StatementCaptions[202] = 'Block Example AVX 2';
StatementCaptions[203] = 'Autoincrement trigger';
end;
else if (SelectedTypes[0] = __dboProcedure) then
StatementCaptions[155] = 'Just a test statement (another test)';
suspend;
exit;
end
if ((StatementID >= 100) and (StatementID < 200)) then
begin
BlockFile = ibec_GetRunDir() + 'Blocks\DefaultBlocks\DragDropBlocks\DDDomains.ibeblock';
if (ibec_FileExists(BlockFile)) then
begin
DomainsBlock = ibec_LoadFromFile(BlockFile);
try
execute ibeblock DomainsBlock(StatementID,
SelectedNames,
SelectedNamesFmt,
SelectedTypes)
returning_values :StatementText;
suspend;
exit;
except
end;
end;
else
begin
StatementText = 'Error: Cannot load IBEBlock from ' + CRLF + BlockFile + CRLF + 'Specified file does not exist.';
suspend;
exit;
end;
end;
else if ((StatementID >= 200) and (StatementID < 300)) then
begin
s = '';
end;
s = '';
foreach (SelectedNames as sName key NameIdx skip nulls) do
begin
s .= sName + CRLF;
end
StatementText = s;
suspend;
end