8 Replies Latest reply: Aug 13, 2011 5:45 AM by Arend_QV RSS

    Error store into a text file

      Hi I have some scripts where I want to store data into a textfile.

      On one system this actions stops when it tries to execute the STORE command. Only the header is written. Then I get the message 'Excecution failed'

      I tested it on another machine and that one is running OK.

      I also tried to store the data first as a qvd file, then load the data and store it as txt, and this is working fine. So I'm a bit confused now.

      Can someone give me a reason were to look to solve this issue, it is very annoying

       

      This is my Store command.

      STORE

      MATNR, MBRSH, MTART, WERKS, LGORT, VKORG, VTWEG, MAKTX, MEINS, MATKL, EXTWG,

      SPART, MTPOS, MSTAE, MSTDE, GROES, TAXKM, KONDM, MTVFP, KAUTB, XCHPF, TRAGR, LADGR, PRCTR, SERNP,

      SBDKZ, STAWN, HERKL, EKGRP, DISMM, DISPO, MINBE, DISLS, BESKZ, PLIFZ, FHORI, LGFSB, LGPBE, XMCNG,

      BWTTY, BKLAS, VPRSV, PEINH, VERPR, HKMAT, ALAND, TATY1, ZSTATUS, PRAT1_2

      From Material INTO C:\Temp\Test.txt (txt, delimiter is '|');

        • Error store into a text file
          Erich Shiino

          Hi,

          I believe you need to load it in a table first, then you store it:

          Material:

          Load

          MATNR, MBRSH, MTART, WERKS, LGORT, VKORG, VTWEG, MAKTX, MEINS, MATKL, EXTWG,

          SPART, MTPOS, MSTAE, MSTDE, GROES, TAXKM, KONDM, MTVFP, KAUTB, XCHPF, TRAGR, LADGR, PRCTR, SERNP,

          SBDKZ, STAWN, HERKL, EKGRP, DISMM, DISPO, MINBE, DISLS, BESKZ, PLIFZ, FHORI, LGFSB, LGPBE, XMCNG,

          BWTTY, BKLAS, VPRSV, PEINH, VERPR, HKMAT, ALAND, TATY1, ZSTATUS, PRAT1_2

          From Material

           

          Store Material into C:\Temp\Test.txt (txt, delimiter is '|');

           

          hope this helps,

           

          Erich

          • Error store into a text file
            Toni Kautto

            Looking in the manual, I do not see that the delimiter would be supported in this context. Does it work without the delimiter?

             

            STORE

            MATNR, MBRSH, MTART, WERKS, LGORT, VKORG, VTWEG, MAKTX, MEINS, MATKL, EXTWG, SPART, MTPOS, MSTAE, MSTDE, GROES, TAXKM, KONDM, MTVFP, KAUTB, XCHPF, TRAGR, LADGR, PRCTR, SERNP, SBDKZ, STAWN, HERKL, EKGRP, DISMM, DISPO, MINBE, DISLS, BESKZ, PLIFZ, FHORI, LGFSB, LGPBE, XMCNG, BWTTY, BKLAS, VPRSV, PEINH, VERPR, HKMAT, ALAND, TATY1, ZSTATUS, PRAT1_2

            FROM Material INTO C:\Temp\Test.txt (txt);

             

            If it is still a problem I would try a couple of things to try to narrow the problem down a bit.

            1. Load only one row or data in the table, so you can determine if it is related to the datat or the store fucntion.

            2. Store all fields of the table instead of named fields, to determine if the problem is within the field name definition

             

            If it is still a problem, please also specify which QV version you are using.

            • Error store into a text file

              I updated to version 10.00.9061.7 SR3 and now the program seems to run again!