Check SQL table and store qvd into different Locations

[ivandrago]

Hi,

I have the attached Document, I need help storing a value into the variable vCount by checking if a record returns by running SQL statement on SQL server. If the variable does have a value of 1 then it will store the qvd in a particular folder.

Thanks

[maxgro · Accepted solution]

//

temp:

Select count(*) as NUMROWS From TableA Where status = '1';

let vCount = Peek('NUMROWS');

trace $(vCount);

DROP Table temp;

Fact:

LOAD * INLINE [

    ID, Product

    1, ABC001

    2, ABC001

    3, ABC002

    4, ABC003

    5, ABC004

    6, ABC007

];

If vCount = 1 Then

     Store Fact into Fact.qvd (QVD);

Else

     Store Fact into Fact_OLD.qvd (QVD);

ENDIF