Re: ServerPorts

Dale E. Reed Jr. ( (no email) )
Mon, 21 Apr 1997 14:41:38 -0700

Marc Elbirt wrote:
>
> At 12:39 PM 4/21/97 -0700, you wrote:
> >It does it via a trigger on the SQL Server side. The trigger may be
> >trying to update UserNameOld, rather than Username (and checking for
> >usernameold from the insert).
>
> Not quite. It actually has to update BOTH of them, becuase UserNameOld
> can't be unassigned.

Just put a default in for usernameold and it will be fine. The problem
arises when you do this with a field that is NOT NULL. If a field does
not allow NULL, then you must explicitly define one, or the insert
statement
must include it.

-- Dale E. Reed Jr.  (daler@iea.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |    http://www.emerald.iea.com