Cannot Add Master Accounts!!

Greg Waugh ( (no email) )
Wed, 29 Jul 1998 13:56:16 -0400

I cannot add new MBRs! If I try in Emerald it just shows the SQL query and
says SQL Command Failed. If I copy the SQL statement and run it in ISQL_w,
this is the response I get.
Nothing has changed on our system in months. This just started happening.
Please help! We're dead in the water if we can't add new accounts!

INSERT statement conflicted with COLUMN FOREIGN KEY constraint
The conflict occurred in database 'Emerald', table 'PayMethods', column
Command has been aborted.


Greg Waugh (
Manager of Systems Operations
Productivity OnLine
Cincinnati, Ohio
(513) 333-3113