<p><!--
.style1 {font-family: Verdana, Arial, Helvetica, sans-serif}
.style3 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12; }
.style4 {font-size: 12px}
.style5 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; }
.style6 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold; }
-->
<script type="text/javascript"></script>
</p>
<p><strong>G4 - User and Password Validation</strong><span class="style4"><span class="style1"><strong> </strong></span></span><br /><br /><span class="style1"><span class="style4"><strong>Application Name:</strong> ctrl_validatelogin <br /><strong>Description:</strong> System Login with user validation<br /><strong><span class="style7"><strong>Fields that will be displayed in the Control</strong></span>: </strong><br />login, password<br /><strong>Table width:</strong> 0 <br /><strong>Table unit width:</strong> Automatic</span></span></p>
<table border="1" cellspacing="0" width="80%" bordercolor="#666666">
<tbody>
<tr>
<td class="style5" width="485"><strong>onValidate Event:</strong></td>
</tr>
<tr>
<td class="style5"><em>sc_lookup(ds,"Select count(*) from seg_users where login=@@##{login}@@## and password=@@##{password}@@##");<br />if({ds[0][0]}&lt;=0)<br />{<br />sc_error_message("Invalid Login or Password.");<br />}</em></td>
</tr>
</tbody>
</table>
<p class="style6">Create new link:</p>
<table border="1" cellspacing="0" bordercolor="#666666">
<tbody>
<tr>
<td class="style5"><strong>Link Type:</strong></td>
<td class="style5">Application</td>
</tr>
<tr>
<td class="style5" width="182"><strong>Application Call:</strong></td>
<td class="style5" width="203">system_menu</td>
</tr>
<tr>
<td class="style5"><strong>Parameters:</strong></td>
<td class="style5">var_logged = Field - login</td>
</tr>
</tbody>
</table>
<p class="style5">&nbsp;</p>
<p class="style5"><strong>Application Name:</strong> system_menu<br /><strong>Description:</strong> System Menu<br /><strong>Orientation:</strong> Horizontal <br /><strong>Applications called through the menu: </strong><br />cons_seek_category, form_a_assign, form_a_blocks, form_a_express<br /><strong>Header LIN2_COL3 =&gt; Value:</strong> User: [var_logged]</p>