Hi
I have a qvw file in 4M size. And a section access script with relpace key words in if clause.
IF reload from qv desktop , the file size is 4M.
IF partail reload from qv desktop ,the file size is 4M;
BUT : IF partail reload by command line like : qv.exe /rp filename.qvw, the file size reduce to 1M.
I spent much time on finding out what 's the different between the 2 modes.
Thank you for every one who can help me and explain this.
section access;
if substringcount(documentname(),'m1') =1 then
replace LOAD [USERID],
[ACCESS],
[PASSWORD],
[ID]
FROM
UserRight.qvd
(qvd) where 1=1;
elseif substringcount(documentname(),'m2') =1 then
replace LOAD [USERID],
[ACCESS],
[PASSWORD],
PRODUCT, [ID]
FROM
UserRight.qvd
(qvd) where 1=1;
elseif substringcount(documentname(),'m3') =1 then
replace LOAD [USERID],
[ACCESS],
[PASSWORD],
[PRODUCT], [YEAR], [ID]
FROM
UserRight.qvd
(qvd) where 1=1;