| Subject | Problem posting a record when an uppercase shadow field is present. |
|---|---|
| Author | Raymond Kennington |
| Post date | 2002-10-15T07:24:46Z |
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
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