1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
|
<html>
<head>
<title>Table</title>
</head>
<body>
{%header:Summary%}
<br><br>
<font size=+2>{%object_name%}</font><br>
Owner: {%owner_name%}<br>
{%sql_security%}<br>
{%object_description%} {%ifeq:{%is_system%}:false:[<a
href="fr://edit_description?parent_window={%parent_window%}&object_handle={%object_handle%}&object_type=TABLE&object_name={%object_name%}">edit</a>]%}
<br><br>
<table cellspacing=1 cellpadding=2 border=0 bgcolor=black>
<tbody>
<tr bgcolor="navy">
{%ifeq:{%is_system%}:false:
<td></td>
%}
<td><b><font color=white>Field</font></b></td>
<td><b><font color=white>Type</font></b></td>
<td><b><font color=white>Not Null</font></b></td>
{%ifeq:{%getglobalconf:DisplayColumnDefault%}:1:
<td><b><font color=white>Default</font></b></td>%}
{%ifeq:{%getglobalconf:DisplayColumnDescription%}:1:
<td><b><font color=white>Description</font></b></td>%}
</tr>
{%foreach:column::
<tr bgcolor="{%alternate:#DDDDFF:#CCCCFF%}">
{%ifeq:{%is_system%}:false:
<td valign="top" nowrap>
<a href="fr://drop_field?parent_window={%parent_window%}&object_handle={%object_handle%}"><img src="{%template_root%}drop.png"></a>
<a href="fr://edit_field?parent_window={%parent_window%}&object_handle={%object_handle%}"><img src="{%template_root%}view.png"></a>
<a href="fr://alter_field?parent_window={%parent_window%}&object_handle={%object_handle%}"><img src="{%template_root%}compute.png"></a>
</td>
%}
<td nowrap valign="top">{%object_name%}</td>
<td nowrap valign="top">{%columninfo:datatype%}</td>
<td nowrap valign="top"><center>{%ifeq:{%columninfo:is_nullable%}:false:<img src="{%template_root%}ok.png">%}</center></td>
{%ifeq:{%getglobalconf:DisplayColumnDefault%}:1:
<td nowrap valign="top">{%columninfo:default_expression%}</td>%}
{%ifeq:{%getglobalconf:DisplayColumnDescription%}:1:
<td valign="top"><font size=-1>{%object_description%} {%ifeq:{%is_system%}:false:[<a
href="fr://edit_description?parent_window={%parent_window%}&object_handle={%object_handle%}&object_type=COLUMN&object_name={%object_name%}">edit</a>]</font>%}
</td>%}
</tr>
%}
</tbody>
</table>
<br><br>
{%ifeq:{%is_system%}:false:
<a href="fr://add_field?parent_window={%parent_window%}&object_handle={%object_handle%}">Add field</a> | <a
href="fr://reorder_fields?parent_window={%parent_window%}&object_handle={%object_handle%}">Reorder fields</a> | <a
href="fr://drop_fields?parent_window={%parent_window%}&object_handle={%object_handle%}">Drop fields</a> | <a
href="fr://alter_relation?parent_window={%parent_window%}&object_handle={%object_handle%}">Generate rebuild script</a>
%}
<br>
<br>
<table border=0 cellspacing=1 cellpadding=3 bgcolor="#999999">
<tr bgcolor="#CCCCFF">
<td>Icon</td>
<td nowrap>click to...</td>
</tr>
<tr bgcolor="#CCCCCC"><td align="center"><img src="{%template_root%}drop.png"></td><td>Drop column</td></tr>
<tr bgcolor="#CCCCCC"><td align="center"><img src="{%template_root%}view.png"></td><td>View column properties</td></tr>
<tr bgcolor="#CCCCCC"><td align="center"><img src="{%template_root%}compute.png"></td><td>Generate rebuild script for that column</td></tr>
</table>
</body>
</html>
|
