Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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......
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
Hi,
Try like this
LOAD
filebasename() as Name,
FileTime() as Time
FROM
*.qvd(qvd);
Regards
ASHFAQ
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
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.
Hi
I tried What Manish Kachhin suggested it is warking fine
thankyou
Hi
This code is warking fine.
thank you...........
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?
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.,.