<p><font face="Verdana" size="2">Is there anyone that can point me into the right direction for creating a function and
triggerthat will do something along these lines:</font><p><font face="Verdana" size="2">I have a table that has router
cardtypes and a status on them:</font><p><font face="Verdana" size="2">TEST_RECORD</font><br /><font face="Verdana"
size="2"> CARD STATUS</font><br /><font face="Verdana" size="2">1. er16-04
0 </font><br /><font face="Verdana" size="2">2. er16-04 er16-08 1</font><br /><font
face="Verdana"size="2">3. ssr8000 ssr8600 0</font><br /><font face="Verdana" size="2">4. er16-04
1</font><br /><font face="Verdana" size="2">5. er16-04 ssr8600 0</font><br /><font
face="Verdana"size="2">6. er-16-04 1</font><p><font face="Verdana" size="2">I need a
triggerwith a function that will check the card type and status and from there determine the over all status of the
testin the test_table. Each tuple represents one test on a specific card(s) and the status is pass or fail.
</font><p><fontface="Verdana" size="2">Here the overall status that would be updated in the test_table status be fail,
becauseof the ssr8600 on line 5.</font><p><font face="Verdana" size="2">I appreciate any suggestions and/or
comments.</font><p><fontface="Arial"> </font><br /><font face="Arial"> </font><br /><b><font face="Verdana"
size="2">RAYHUNTER</font></b><br /><font face="Verdana" size="2">Automated Test Group</font><br /><font face="Verdana"
size="2">SoftwareSupport Engineer</font><br /><font face="Arial"> </font><br /><b><font face="Verdana"
size="2">ENTERASYSNETWORKS</font></b><br /><font face="Arial"> </font><br /><font face="Verdana" size="2">Internal:
53888</font><br/><font face="Verdana" size="2">Phone: 801 887-9888</font><br /><font face="Verdana"
size="2">Fax: 801 972-5789</font><br /><font face="Verdana" size="2">Cellular: 801 698-0622</font><br
/><fontface="Verdana" size="2">E-mail: <u> </u></font><u><font color="#0000FF" face="Verdana"
size="2">rhunter@enterasys.com</font></u><br/><font face="Arial"> </font><br /><u><font color="#0000FF" face="Verdana"
size="2">www.enterasys.com</font></u>