home *** CD-ROM | disk | FTP | other *** search
/ PC Online 1998 November / PCO_1198.ISO / filesbbs / os2 / os2www.arj / OS2WWW.ZIP / SYS406.R8 / ADMIN / DBACCESS / TABREF.INC < prev    next >
Encoding:
Text File  |  1996-11-29  |  1.2 KB  |  50 lines
  1. <form method=post action=/admin/dbaccess/tabqry.htm?connect=<!--#echo format=escaped var=connect-->&vendor=<!--#echo format=escaped var=vendor-->&server=<!--#echo format=escaped var=server-->&datasource=<!--#echo format=escaped var=datasource-->&userid=<!--#echo format=escaped var=userid-->&password=<!--#echo format=escaped var=password-->&table=<!--#echo format=escaped var=table-->>
  2.  
  3. <table border=1>
  4. <tr bgcolor="#000080">
  5. <th>
  6. <font face=helv color="#FFFFFF">
  7. Refine the Query for Table <!--#echo var=table-->
  8. </th></tr>
  9.  
  10. <tr bgcolor="#D0D0D0">
  11. <td><font size=-1 face=arial>
  12.     <b>Select Columns</b>
  13. </td>
  14. </tr>
  15.  
  16. <tr>
  17. <td>
  18.     <select multiple name=columns size=12>
  19.     <!--#database
  20.         dict            =    columns(,,@table)
  21.         connect        =    "@connect"
  22.         server        =    "@server"
  23.         datasource    =    "@datasource"
  24.         vendor        =    "@vendor"
  25.         userid        =    "@userid"
  26.         password        =    "@password"
  27.         row            =    "<option>@Column_Name"
  28.     -->
  29.     </select>
  30. </td>
  31. </tr>
  32.  
  33. <tr bgcolor="#D0D0D0">
  34. <td><font size=-1 face=arial>
  35.     <b>Maximum Rows</b>
  36. </td>
  37. </tr>
  38.  
  39. <tr>
  40. <td>
  41.     <input type=text name=maxrows size=16 value=256>
  42. </td>
  43. </tr>
  44. </table>
  45.  
  46. <p>
  47. <input type=submit name=submit value="View Query Result">
  48. </form>
  49.  
  50.