Skip to main content

Macro SQL - multiple @StoreX




  • Official comment

    Hi Jay,

    I'm not sure if I misunderstood something here, but you can use:

    MultiSetFromSql(@STORE1|@STORE2|SELECT CardName, Balance FROM OCRD WHERE CardCode ='C20000')
    MessageBox(@STORE1 @STORE2);

    Best regards,


  • SSP Automation
    Thank you for your request. It has been scheduled for review by the development team that will get back to you should there be questions.
    (Please note that as we are user-driven we can't guarantee that your request will be met unless it gets many votes and/or fit the product vision)
    Read more about the Feature Request process here
    [Internal Id: 57290]
  • Dave Gutman

    This works on my test system:

    @STORE1 = SQL('SELECT CardType FROM OCRD WHERE CardCode = $[$5.0.0]');

    @STORE2 = @STORE1; 

  • Rasmus Jensen

    I don't think that is what Jay is after... The request is to set two different @Store values with two different values using only a single SQL Sentence.

    It is unfortunately not something we can do right now :-(

  • Jay Cheah

    Rasmus Jensen yes that is exactly what i want - too bad to hear that is a limitation. 

    It would a BIG performance improvement for sure - esp when we have multiple validations on screen. 

  • Rasmus Jensen

    If the macro is called from a B1 Validation you might be able to leverage the SQL condition keyword system that sort of does the same as you request: see more here -

  • Jay Cheah

    Thomas i tried :

    MultiSetFromSql(@store1|@store3|SELECT T0."U_UDF1",T0."U_UDF2" FROM OITM T0 WHERE T0."ItemCode" = $[$38.1.0])

    and this triggered some exception, i don't know exactly what is wrong if any from your statement or it's just a limitation of the multiset. I'm on HANA btw, hence the multiple double quotes..

    if i split the statements into 2 separate SQL calls, with the same syntax, then it works fine

Please sign in to leave a comment.