<p>Untitled Document <!--
.style1 {font-family: Verdana, Arial, Helvetica, sans-serif}
.style2 {font-size: 12px}
.style3 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; }
.style4 {font-size: 12}
-->
<script type="text/javascript"></script>
</p>
<p><span class="style1"><span class="style2"><span class="style4"><span class="style2"><strong>MCR1: How to create a simple method</strong><strong> </strong><br /><br /><strong>Application Name: </strong>login_</span><span class="style1"><span class="style2"><span class="style4"><span class="style2">simple_</span></span></span></span><span class="style2">method<br /><strong>Description: </strong>Control Application effecting login in the system with a simple method of user validation.<br /><strong>Fields that will be shown in the control: </strong><br />login, password<br /><strong>Table width:</strong> 0<br /></span><span class="style7"><strong>Table width unit: </strong>Automatic</span><span class="style2"><br /><strong>Header -&gt; Application Title: </strong>Using simple method</span></span></span></span></p>
<table style="height: 164px;" border="1" cellspacing="0" width="455" bordercolor="#666666">
<tbody>
<tr>
<td class="style3" width="188"><strong>New Method:</strong></td>
<td class="style3" width="380">userValidate</td>
</tr>
<tr>
<td class="style3">
<p><strong>Code:</strong></p>
</td>
<td class="style3"><em>sc_lookup(ds,"Select count(*) from seg_users where login='{login}' and password='{password}'");<br /><br />if({ds[0][0]}&lt;=0)<br />{<br />sc_error_message("Invalid User or Password!");<br />}</em></td>
</tr>
</tbody>
</table>