General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Field does not accept null values
sele ;
iif( isnull(sum(b.totcxlcnt)),;
iif(isnull(sum(a.totsalecnt)),000,sum(a.totsalecnt)),;
sum(a.totsalecnt)-sum(b.totcxlcnt) ) as tsaleadj,;
From qcTSaleRp a FULL JOIN qcTCxlRp b ;
ON a.repid==b.repid AND a.pub==b.pub;
Group by a.Repid,a.Project;
Order by a.Repid,a.Project;
Into cursor qcSalCxl
... is still generating the message "TSaleAdj does not accept null values" I know there is something strange going on during the Select, but I don't know where nulls would come from if i'm checking for nulls. This problem is also data dependant- sometimes it works, sometimes it doesn't. (which makes troubleshooting that much easier!)
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only