OK, I removed all concatenation programming, and programmed in a test that HAS to be flagged, as so:
on-change of Firstname element
var vFull as string
vFull = Firstname
// Checks to see if it's unique
If @IsUnique(Firstname, vFull) = 0
THEN
{
@MsgBox("This name is not unique.", "It already exists in the database.", "Please change the name or discard this record.")
}
ELSE
// Sets the Full Name
{
FullName = vFull
}
I entered "Scott" in the Firstname field, and tabbed out. I already exist in the database. No error message, and Fullname happily filled with "Scott".
Then I did this:
var vFull as string
// Capitalizes each word
cuInitialCaps()
vFull = "Scott"
// Checks to see if it's unique
If @IsUnique(Firstname, vFull) = 0
THEN
{
@MsgBox("This name is not unique.", "It already exists in the database.", "Please change the name or discard this record.")
}
ELSE
// Sets the Full Name
{
FullName = vFull
}
Still no error, Fullname fills with Scott.
Then I did this, turned off the variable entirely:
var vFull as string
// vFull = "Scott"
// Checks to see if it's unique
If @IsUnique(Firstname, "Scott") = 0
THEN
{
@MsgBox("This name is not unique.", "It already exists in the database.", "Please change the name or discard this record.")
}
ELSE
// Sets the Full Name
{
FullName = vFull
}
Still no error message.