File: create_selectable_execute_block.template

package info (click to toggle)
flamerobin 0.9.13.ds.2-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 7,300 kB
  • sloc: cpp: 59,818; sh: 10,505; xml: 1,029; ansic: 302; makefile: 27
file content (20 lines) | stat: -rw-r--r-- 731 bytes parent folder | download | duplicates (2)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
{%--:Uncomment to edit template info visually.%}{%--:{%edit_info%}{%abort%}%}{%edit_conf%}{%kw:set term !! ;

execute block
returns%} ( {%foreach:column:, :{%ifcontains:{%getconf:{%object_path%}/columnNames%}:{%object_name%}:
{%tab%}{%object_quoted_name%} {%columninfo:source%}%}%}
)
{%kw:as
begin
{%tab%}for select%} {%foreach:column:, :{%ifcontains:{%getconf:{%object_path%}/columnNames%}:{%object_name%}:
{%tab%}{%tab%}a.{%object_quoted_name%}%}%}
{%tab%}{%kw:from%} {%object_quoted_name%} a
{%tab%}{%kw:into%} {%foreach:column:, :{%ifcontains:{%getconf:{%object_path%}/columnNames%}:{%object_name%}:
{%tab%}{%tab%}{%object_quoted_name%}%}%} 
{%tab%}{%kw:do
{%tab%}begin
{%tab%}{%tab%}suspend;
{%tab%}end
end!!

set term%} ; !!