How to insert a variable to a sql query?
I need to know how I can insert a variable to a sql query.
I created the following query:
SELECT T2.NumOfDays FROM OQUT T0, OCTG T1, CDC1 T2 WHERE T0.GroupNum = T1.GroupNum AND T1.DiscCode = T2.CdcCode AND T0.DocNum = current OQUT-Docnum
How can I realize that I get the current DocNum from OQUT?
The query is for UDFs.
That is because the auto refresh may not work base on your setting. Try to change the field for refresh to the one works most. Otherwise, you have to manually update when necessary.