Skip to Content
0
Former Member
Aug 04, 2016 at 08:54 AM

Validation Query

120 Views

Hi,

I'm trying to create a validation for a button. I have UDF in the OCRD table called U_DestType. I would like the button that this validation is attached to to check for certain values in this column before processing.

So far I have:

IF(SELECT T0.U_DestType FROM OCRD T0 INNER JOIN ODLN T1 ON T1.CardCode = T0.CardCode) NOT IN ('1','2','6') WHERE ODLN.DocEntry = '123456'

BEGIN

SELECT 'SHOW_ERROR' FOR BROWSE

END

but obviously this is wrong. Can anyone suggest what I need to do to get this to work?

Many thanks,

John