Ignore:
Timestamp:
Feb 18, 2000, 1:42:08 PM (26 years ago)
Author:
bird
Message:

Read more of the function header into the database.
Stateupd is changed to do this and the database is expanded with new fields.
The sample is partly updated.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/tools/database/sample.kSqlHtml

    r2765 r2818  
    1 <!-- $Id: sample.kSqlHtml,v 1.2 2000-02-12 17:55:04 bird Exp $
     1<!-- $Id: sample.kSqlHtml,v 1.3 2000-02-18 12:42:08 bird Exp $
    22  --
    33  -- kSqlHTML Template Sample.
     
    186186<BODY>
    187187<H1>Details on APIs in $(dllname)</H1>
     188<P>
     189<IMAGE SRC="odin32Dll$(dllname).gif">
     190</P>
    188191<TABLE BORDER=1 BORDERCOLOR="#000000" CELLPADDING=4 CELLSPACING=0>
    189192    <THEAD>
    190         <TR VALIGN=TOP> <TH>Ordinal</TH> <TH>API name</TH> <TH>State</TH> </TR>
     193        <TR VALIGN=TOP> <TH>Ordinal</TH> <TH>API name</TH> <TH>Author(s)</TH> <TH>State</TH> </TR>
    191194    </THEAD>
    192195    <TBODY>
    193196        <!kSql sql="SELECT ordinal,
    194197                           function.name AS functionname,
    195                            state.name AS statename
     198                           state.name AS statename,
     199                           function.refcode AS fnrefcode
    196200                       FROM function, state
    197201                       WHERE state.refcode = state
    198                              AND dll = $(dllrefcode)"
     202                             AND dll = $(dllrefcode)
     203                       ORDER BY function.name"
    199204        ><TR>
    200205            <TD><P ALIGN=RIGHT>$(ordinal)<P></TD>
    201206            <TD><P ALIGN=LEFT>$(functionname)<P></TD>
     207            <TD><!kSql sql="SELECT name AS authorname
     208                            FROM fnauthor fna, author a
     209                            WHERE function = $(fnrefcode) AND fna.author = a.refcode"
     210           ><P ALIGN=RIGHT>$(authorname)<P><!/kSql>
     211            </TD>
    202212            <TD><P ALIGN=LEFT>$(statename)<P></TD>
    203213        </TR><!/kSql>
Note: See TracChangeset for help on using the changeset viewer.