|
Last change
on this file since 3204 was 2765, checked in by bird, 26 years ago |
|
Some new reports.
General bugfixes and new features.
|
|
File size:
1.5 KB
|
| Line | |
|---|
| 1 | <!-- $Id: Aliases.kSqlHtml,v 1.1 2000-02-12 17:55:02 bird Exp $
|
|---|
| 2 | --
|
|---|
| 3 | -- kSqlHTML Template for report showing function aliases detected.
|
|---|
| 4 | --
|
|---|
| 5 | -- Copyright (c) 2000 knut st. osmundsen (knut.stange.osmundsen@pmsc.no)
|
|---|
| 6 | --
|
|---|
| 7 | -- Project Odin Software License can be found in LICENSE.TXT
|
|---|
| 8 | -->
|
|---|
| 9 |
|
|---|
| 10 | <!kTemplate filename="Aliases.html"><HTML>
|
|---|
| 11 | <Title>Odin32 DB Alias report</Title>
|
|---|
| 12 | <BODY>
|
|---|
| 13 | <CENTER><H1>Odin32 DB Alias report</H1></CENTER>
|
|---|
| 14 | <!kSql sql="SELECT CURDATE() AS currentdate">
|
|---|
| 15 | <CENTER><H2>- $(currentdate) -</H2></CENTER>
|
|---|
| 16 | </!kSql>
|
|---|
| 17 |
|
|---|
| 18 | <!-- Table of aliased functiones -->
|
|---|
| 19 | <TABLE BORDER=1 BORDERCOLOR="#000000" CELLPADDING=4 CELLSPACING=0>
|
|---|
| 20 | <THEAD>
|
|---|
| 21 | <TR VALIGN=TOP> <TH>From</TH> <TH>To</TH> </TR>
|
|---|
| 22 | </THEAD>
|
|---|
| 23 | <TBODY>
|
|---|
| 24 | <!kSql sql="SELECT
|
|---|
| 25 | d1.name AS f1dll,
|
|---|
| 26 | f1.name AS f1name,
|
|---|
| 27 | f1.intname AS f1intname,
|
|---|
| 28 | d2.name AS f2dll,
|
|---|
| 29 | f2.name AS f2name,
|
|---|
| 30 | f2.intname AS f2intname
|
|---|
| 31 | FROM function f1
|
|---|
| 32 | LEFT OUTER JOIN function f2 ON f1.aliasfn = f2.refcode
|
|---|
| 33 | LEFT JOIN dll d1 ON f1.dll = d1.refcode
|
|---|
| 34 | LEFT JOIN dll d2 ON f2.dll = d2.refcode
|
|---|
| 35 | WHERE f1.aliasfn >= 0
|
|---|
| 36 | ORDER BY d1.name, f1.name
|
|---|
| 37 | "><TR>
|
|---|
| 38 | <TD><P ALIGN=LEFT>$(f1dll).$(f1name)($(f1intname))<P></TD>
|
|---|
| 39 | <TD><P ALIGN=LEFT>$(f2dll).$(f2name)($(f2intname))<P></TD>
|
|---|
| 40 | </TR>
|
|---|
| 41 | <!/kSql>
|
|---|
| 42 | </TBODY>
|
|---|
| 43 | </TABLE>
|
|---|
| 44 | </BODY>
|
|---|
| 45 | </HTML>
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
