B1UP - get store value does not open in query

Alain Seys

Hy,

i have created a universal function that checks on the customer order if an email is been send or not if send this updates a UDF with some formated data on the order this works as expected.

but if we have a query that links to an order the orders does not open where the contion is met.

if i remove the click update button this works 

We use universal function on data load any sugestions to fix this ? 

@store1 = SQL ('SELECT TOP 1 CONCAT(U_User,'/',U_Ref,'/',U_Date,'/',U_Destinee) FROM [dbo].[@SYM3_EMAILTRACE] WHERE U_CardCode = $[$4.0.0] AND U_DocNum =$[$8.0.NUMBER] ORDER BY Code DESC)

IF(@store1 != '' )
BEGIN
    StatusBar(Query check email contains data|S); 
    Set($[$BOYX_3.0.0]|@store1);
    Click($[$1.0.0]);  
END
ELSE
BEGIN
    StatusBar(Query check email has no data|W); 
END

Comments

0 comments

Please sign in to leave a comment.