Selecting required qvd's from a location while reload

[rsdhavle]

Is there any way to select particular qvd's while reloading data?

Example:

I have some qvd's available on one folder location

D:\ qvd1

     qvd2

     qvd3

     qvd4 etc

While reloading the data i need to load data of qvd 3 only and i have to make this option available while reloading so that user can select qvd 1,2 or 3 whatever according to his preference. Is there any way to do so?

If yes What is the code needs to be written in the script?

[ashwanin]

you can do it by Just reloading the qvd by selecting one by one. Else put qvd's in a folder, with some specific name and e.g 201201 to 201212 for 2012 and  201301 to 201312 for 2013 qvds.

Now if you want to reload only 2013 qvds's then at the time of reload just put path\2013*qvd 

[ashwanin]

example

Load

as,

dgh

FROM

(qvd);

[alexandros17]

Use

Input(str cue [, str caption])

This function can be used in the
script only and opens an input box that prompts the user for a value during the
script execution. The parameters cue and caption are used as message and caption
texts, respectively. The function returns the entered value.

The input box function returns
NULL if the dialog is cancelled, closed or cannot be shown.

Example:

Load
Input('Enter value', 'Input box') as v,
Recno () as r

autogenerate 3;

[rsdhavle]

HI,

Thanks. Can you please tell me where should i mention the folder location from which one of the qvd file needs to be picked up?

[ashwanin]

In Script

[rsdhavle]

Hi AShwani,

You are telling about simple load from qvd i want the approach which Alessandri is talking about as i need select qvd's dynamically while reloading

[alexandros17]

Here is a complete example

Hope it helps

LOAD Input('Enter value', 'Input box') as v autogenerate 1;

LET myFolder = Peek('v');

DROP Table TMP;



DDD:

NoConcatenate

LOAD * Resident $(myFolder);