script meaning

[#1]

Hi All,

What is this script means, how it works?

IF vTable = 'ALL' OR vTable = 'TableA' THEN

[TableA]:

LOAD *

FROM

[$(QVDPath)A.qvd]

(qvd);

store [TableA] into [$(QVDPath)TableA.qvd] (qvd);

drop table [TableA];

[TableB]:

LOAD *

FROM

[$(QVDPath)B.qvd]

(qvd);

store [TableB] into [$(QVDPath)TableB.qvd] (qvd);

drop table [TableB];

[TableC]:

LOAD *

FROM

[$(QVDPath)C.qvd]

(qvd);

store [TableC] into [$(QVDPath)TableC.qvd] (qvd);

drop table [TableC];

[TableD]:

LOAD *

FROM

[$(QVDPath)D.qvd]

(qvd);

store [TableD] into [$(QVDPath)TableD.qvd] (qvd);

drop table [TableD];

ENDIF

[jonathandienst]

Are you asking what does the IF/ENDIF statement does? The script between these statements will only execute of the IF condition evaluates to true - in other words, if the variable vTable is set to to 'ALL' to 'TableA'

[#3]

Yes Jonathan, My doubt is how to set these conditions? How to execute them? I am quite new for this concept. Could you please explain in details?

[vcanale]

Hi,
The Load of the tables [TableA], [TableB], [TableC]. [TableD] will happen only if vTable = 'ALL' OR vTable = 'TableA'

[jyothish8807]

Hi Annio,

Over here vTable is a variable and it can have only one value at a time. A per your code,

If the variable “vTable” contains value either 'ALL' OR 'TableA' then it will meet the condition and load all the tables mentioned below.

Regards

KC

[wallerjc]

Hi

If your variable "vTable" is set to "ALL" or "TableA" doesn't seem to matter here, it will still load TableA and TableB

You might need to show us more code to help you out further.

Thanks,

james.

[rupamjyotidas]

You need to find out where in your script the values of 'vTable'  is set. Probably in your script or in Publisher