Forum Discussion

Mrunal's avatar
Mrunal
Contributor
11 years ago
Solved

Is it possible to add Frompath and Topath from DB table variable in aqfilesystems.move method?

Hello,   I am trying to call path value from DbTable values. I read one article which says Path requires "string" as its value.    code:- aqFileSystem.MoveFile("C:\\TC", "C:\\TC\\Temp", false)) ...
  • joseph_michaud's avatar
    joseph_michaud
    11 years ago

    You probably want to do something like

     

      from = KeywordTests.Test1.Variables.DB.Value("A");
  to = "D:\\New folder\\Copy";
  aqFileSystem.CopyFile(from, to, false);

     

     If you've set up your DB to use the first row as the column name, then you'll need to use Value("Path") ,

Marsha_R's avatar
Marsha_R
Icon for Champion Level 3 rankChampion Level 3
11 years ago

What happened when you tried it?

  • Mrunal's avatar
    Mrunal
    Contributor
    11 years ago

    Hi,

     

    My code is

     

    aqFileSystem.CopyFile("KeywordTests.Test1.Variables.DB.Value(A)", "D:\\New folder\\Copy", false)

     

    for excel details see attached screenshot.

     

     

    Error Details :- An error occurred while copying a file (folder). In additional Info it says no file corresponds to - followed by "Test Path".

     

     

     

     

    • joseph_michaud's avatar
      joseph_michaud
      Icon for Staff rankStaff
      11 years ago

      You probably want to do something like

       

        from = KeywordTests.Test1.Variables.DB.Value("A");
  to = "D:\\New folder\\Copy";
  aqFileSystem.CopyFile(from, to, false);

       

       If you've set up your DB to use the first row as the column name, then you'll need to use Value("Path") ,

      • Mrunal's avatar
        Mrunal
        Contributor
        11 years ago

        Hi Joseph,

         

        Thanks for quick reply.

         

        By using code suggested by you, I am able to copy/move file from one location to other by using fromPath value from variable.

         

        I want one more help.

        I want to take both "from path" and "to path" from variable.

         

        My Code is:-

         

        function Move()
        {
        var from = KeywordTests.Test1.Variables.DB.Value("frPath");
        var to = KeywordTests.Test1.Variables.DB.Value("toPath")

        Log.Message(aqFileSystem.CopyFile(from, to, false));
        }

         

        It gives me error as:- 

        Incorrect path: D:\\New folder\\Move
         
        Attaching my excel sheet here.
         
        Thanks in Advance.