I want to insert values in child table.I have seq-num field which is auto populated.so I hav not used the field itself in insert querry.
While promoting in changeman I get SQL code -407 .
Seq num is defined as smallint not null.
SQL 407 means trying to insert null value in a field declared as not null.I havnt used the field itself in insert.Any idea how to solve it??
I tried inserting the field also.I got SQL -206. Object used in a place which is not valid.I.hav no clue..Pls help
Thanks in advance
Joined: 10 May 2007 Posts: 2180 Location: Hampshire, UK
What has changeman got to do with this? When promoting, object are moved not executed. Are you saying that before promotion the objects worked in the environment but failed after in the same environment or failed in a different environment. If the latter then there is a discrepancy between environments. If you did not test before promotion then go shoot yourself.