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