code/.docs/prototype_Global/function_helma.sqlshell.Datasource.prototype.getSchemas.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN">
   2 <html>
   3
   4 <head>
   5         <title></title>
   6         <style type="text/css">
   7
   8         body, p, td, th, li {
   9                 font-family: verdana, sans-serif;
  10                 font-size: 10pt;
  11         }
  12
  13         big.top {
  14                 font-size: 18pt;
  15                 font-weight: bold;
  16         }
  17
  18         big {
  19                 font-size: 13pt;
  20                 font-weight: bold;
  21         }
  22
  23         a {
  24                 font-weight:bold;
  25                 color: #cc3333;
  26                 text-decoration:none;
  27         }
  28         a:hover {
  29                 text-decoration:underline;
  30         }
  31
  32         .navig  {
  33                 font-size: 9px;
  34                 text-decoration: none;
  35                 font-weight:normal;
  36         }
  37
  38         li {
  39                 padding-bottom: 5px;
  40         }
  41
  42
  43         .mainbox        {
  44                 border-color:#999999;
  45                 padding-top:5px;
  46                 padding-bottom:5px;
  47                 border-bottom-width:1px;
  48                 border-bottom-style:dotted;
  49         }
  50
  51         .headline {
  52                 font-weight:bold;
  53                 background:#dfdfdf;
  54                 border-color:#999999;
  55                 padding-top:5px;
  56                 padding-bottom:5px;
  57         }
  58
  59         </style>
  60 </head>
  61
  62 <body>
  63
  64 <table width="90%" border="0" cellspacing="1" cellpadding="5">
  65 <tr>
  66         <td class="headline">
  67         <big><tt>Global.helma.sqlshell.Datasource.prototype.getSchemas&nbsp;(meta)</tt></big><br>
  68         </td>
  69 </tr>
  70
  71 <tr>
  72         <td class="mainbox">
  73         Get an array of schema names defined in the current database.<br><br>
  74
  75         <ul>
  76
  77
  78
  79
  80
  81
  82         </ul>
  83         </td>
  84 </tr>
  85 </table>
  86
  87 <table width="90%" border="0" cellspacing="1" cellpadding="5">
  88 <tr>
  89         <td>Sourcecode in helmaTools.zip/Global/helma.sqlshell.js:
  90         <pre><font color="#aaaaaa">115:</font>   helma.sqlshell.Datasource.prototype.getSchemas = function(meta) {
  91 <font color="#aaaaaa">116:</font>   <font color="#33aa00">    // get available schemas and set up an array for the drop down box:
  92 <font color="#aaaaaa">117:</font>   </font>    var schemas = [];
  93 <font color="#aaaaaa">118:</font>       var t = meta.getSchemas();
  94 <font color="#aaaaaa">119:</font>       while (t.next()) {
  95 <font color="#aaaaaa">120:</font>           var s = t.getString(1);
  96 <font color="#aaaaaa">121:</font>           schemas.push([s, s]);
  97 <font color="#aaaaaa">122:</font>       }
  98 <font color="#aaaaaa">123:</font>       return schemas;
  99 <font color="#aaaaaa">124:</font>  }
 100 </pre>
 101         </td>
 102 </tr>
 103
 104 </table>
 105
 106
 107
 108
 109
 110 </body>
 111 </html>