Unique records and CAPITALS

Use BeforeAdd/BeforeEdit events for this purpose.
See sample action "Check if record exists".
To convert data to upper case use strtoupper() function:

Use BeforeAdd/BeforeEdit events for this purpose.

1. Where do I put the convert to capitals code?
   
2. I entered the following for the custom code:
   
   function BeforeRegister(&$values)
   
   {
   
   global $conn;
   
   $strSQLExists = "select * from pcba where upc='".$values["upc"]."'";
   
   $rsExists = db_query($strSQLExists,$conn);
   
   $data=db_fetch_array($rsExists);
   
   if($data)
   
   {
   
   echo "UPC already exists!!";
   
   return false;
   
   }
   
   else
   
   {
   
   return true;
   
   }
   
   }
   When I try entering a duplicate it allows me and does not prompt me "UPC already exists!"
   
   This code is enterd in "Table Events / Add Page / Before record added & Before record updated"
   Thanks in advance!!!

I'm talking about BeforeAdd/BeforeEdit events while you trying to use it in BeforeRegister event.

I'm talking about BeforeAdd/BeforeEdit events while you trying to use it in BeforeRegister event.

Sorry....the actual code is the following:
function BeforeAdd(&$values)

{

global $conn;

$strSQLExists = "select * from pcba where upc='".$values["upc"]."'";

$rsExists = db_query($strSQLExists,$conn);

$data=db_fetch_array($rsExists);

if($data)

{

echo "UPC already exists!!";

return false;

}

else

{

return true;

}

}
Do I need to add every field if I only want to search for duplicates in the upc field?

The database is pcba and there are 10 field in total.
Thanks again!

This code looks correct and you don't need to add all fields if you only search for duplicates in UPC field.

This code looks correct and you don't need to add all fields if you only search for duplicates in UPC field.

Working now....thank you!