qvd create time and qvd names

[hari8088]

Hi all.

     I have one path(system path) in that path lot of qvds are there for example 10 qvds are there .with the help of path i want to find qvd names and qvd create time.

Any suggestions..

Thanks......

[ashfaq_haseeb]

Hi,

Try like this

LOAD

     filebasename() as Name,

     FileTime() as Time

FROM

*.qvd(qvd);

Regards

ASHFAQ

[MK_QSL · Accepted solution]

Let vQVDPath = 'C:\Users\QVD';

For Each File in FileList(vQVDPath& '\*.qvd')

     Load

      FileName() as TableName

      ,FileTime() as FileCreateTime

      ,QvdCreateTime('$(File)') as QVDCreateTime

      ,SubField(SubField('$(File)','\',-1),'.',1) as QVDTableName

     From [$(File)] (qvd);

Next File

[Gabriel]

Hi,

Have you tried MRKachhiaIMP suggestion yet?

[Peter_Cammaert]

Have you?

Same problem as with Ashfaq's code: a LOAD creates a file details-row for every single record in every single QVD. Imagine that the first QVD contains 1000000 rows. Then your scan of the first QVD will store 1000000 identical rows in your resident table.

[hari8088]

Hi

   I tried What Manish Kachhin suggested it is warking fine

thankyou

[hari8088]

Hi

   This code is warking fine.

thank you...........

[Peter_Cammaert]

How many rows do you have in the resulting table? (check Settings->Document Properties->Tables and select the QVD details line in the upper overview) And how many QVD's in your directory?

[MK_QSL]

If you got your answer, kindly close the thread by selecting correct/helpful answer, so that others having same problem can take advantage of this thread.,.