Skip to Content
0
Former Member
Apr 04, 2011 at 05:45 AM

Validation on Master Project

27 Views

Hi, I need to make a validation on Master Project, is it possible to do that?

I have 1 UDF here, and every project has this 1 UDF and I'm about to make a validation that each project will only have 1 UDF.

I tried this :

SELECT U_ProjectDetail, PrjCode

FROM OPRJ

WHERE U_ProjectDetail IN (SELECT U_ProjectDetail FROM OPRJ)

AND PrjCode = @list_of_cols_val_tab_del

AND @object_type = '63'

But seems not the right way to validate this condition.

Anyone can help?

Thank you,

-Flo