[Emerald] credit card batching problem

Josh Hillman ( (no email) )
Tue, 19 Oct 1999 17:50:15 -0400

I ran an auto-batch in Emerald 2.5.278 (using a copy of the Emerald db on my
workstation) and ran into the following problem when clicking on Batch Out:

SQL Server Error: 515 Attempt to insert the value NULL into column
'ProcDate', table 'Emerald.dbo.External.Trans'; column does not allow nulls.
Insert Fails.
State=3, Severity=16

(getdate()) is set in SQL Ent. Manager as the default value for that
particular column, but it doesn't appear to be having an effect. At the
moment, that table is completely empty because it's never been used before.
The main Emerald database was created in October in 1996.

What do I need to do to fix this?

Emerald 2.5.278 / SQL 6.5 SP5a


For more information about this list (including removal) go to: