Subject Problem posting a record when an uppercase shadow field is present.
Author Raymond Kennington
The table structure is like:

ID Integer
Vendor Char(30) NOT NULL
S_Vendor Char(30) NOT NULL UNIQUE

with an AfterUpdate trigger that updates "S Vendor" as UPPER(Vendor).

ISC ERROR: validation error column S_Vendor, value NULL.

How do I correct this assuming that S_Vendor must be unique but Vendor need not be unique?
--
Raymond Kennington
Programming Solutions
W2W Team B