Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Sanliza
Contributor
Contributor

Is it ok if there are 2 semicolon before STORE when creating a qvd?

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);

1 Solution

Accepted Solutions
stevejoyce
Specialist II
Specialist II

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);

View solution in original post

3 Replies
stevejoyce
Specialist II
Specialist II

No,  ; is just the end of a statement.  it's like your closing out no statement after the first semi-colon.

Sanliza
Contributor
Contributor
Author

Thank you! Do you know how can this impact the data stored in the QVD file? I cannot  reload the data yet to compare...

stevejoyce
Specialist II
Specialist II

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);