3 Replies Latest reply: Feb 18, 2014 6:56 AM by Hartley Julian RSS

    Loop not creating table

    Hartley Julian

      Hi All,

      I've obviously missing something obvious here! i have this loop, which is meant to cyle through qvw's stored in a certain directory and return simple file information... however it is not returning a table at all. I have debugged and it steps through the files but no table 'Data' is created!

       

      SET FilePath='*.qvw';

       

      sub DoDir (Dir)

       

      for each File in filelist (Dir&'\'&'$(FilePath)')

      SET sFile = $(File);

      Data:

      Load 'Test' as FileName;

       

      next File

      end sub

      //Call the procedure "DoDir" to check for files in this directory.

       

      call DoDir ('D:\Work\Reference');