cancel
Showing results for 
Search instead for 
Did you mean: 

SAP B1 UP '@STORE' syntax in Universal Function macros

former_member675796
Participant
0 Kudos
1,239

Hi experts!

Based on Boyum's documentation it would seem that it is possible to assign the result of a Subquery to a @STOREXX value, like:

@STORE1 = (SELECT LastPurPrc FROM OITM WHERE ItemCode LIKE '[$38.14.0]').

However, this doesn't seem to be working for me when I try to use it inside a macro? In fact, I can't seem to use @STORE values at all in my macros.

For example, this short snippet of code recommended in the Boyum documentation does not work for me inside a validation.

'DECLARE @STORE1;

@STORE1 = 2;

StatusBar(Store1 value is @STORE1|Warning);'

What am I doing wrong?

Thanks experts!

Alex

View Entire Topic
former_member998910
Discoverer
0 Kudos

Hi,

try with

@STORE1 = SQL('SELECT "LastPurPrc" FROM OITM WHERE "ItemCode" LIKE '$[$38.14.0]').

Regards

Davide