Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I am analyzing a code and I came across 2 semicolons before STORE when creating a qvd file. Do you know if this is going to cause any kind of conflict or missing data. So far the app works fine, I am concerned about the data saved in the qvd file. Thanks
...
FROM "TableTest"
WHERE
Code NOT LIKE 'L5568' ;;
Store SalesTest into [lib://$(vS2)/SalesTest.qvd] (qvd);
it's not going to impact it. your table loaded in memory is done after the first semi-colon. and a separate statement stores it. for example you could have below. This vVariable has no impact on the storing.
FROM "TableTest"
WHERE
Code NOT LIKE 'L5568' ;;
let vVariable = Today();
Store SalesTest into [lib://$(vS2)/SalesTest.qvd] (qvd);
No, ; is just the end of a statement. it's like your closing out no statement after the first semi-colon.
Thank you! Do you know how can this impact the data stored in the QVD file? I cannot reload the data yet to compare...
it's not going to impact it. your table loaded in memory is done after the first semi-colon. and a separate statement stores it. for example you could have below. This vVariable has no impact on the storing.
FROM "TableTest"
WHERE
Code NOT LIKE 'L5568' ;;
let vVariable = Today();
Store SalesTest into [lib://$(vS2)/SalesTest.qvd] (qvd);