4 Replies Latest reply: Oct 16, 2014 2:18 PM by Anand Chouhan RSS

    QVD

    Suresh Babu

      HOW QVDS CRATE

      DATA IS IN IBEXPERT ( IT IS ONE OF DATA BASE)

      DATA IS COLLECTING FORM SERVER

        • Re: QVD
          Gysbert Wassenaar

          Your caps lock key seems to be broken. Please buy a new keyboard.

          And don't cross post:

           

          Finally, read the help file. Look for the STORE command.

          • Re: QVD
            Nils Morris

            Hi

            This is an example of how to create a QVD.


            Customers:

            Load

                 Company,

                 CompanyID,

                 DivisionID,

                 Country

                 SQL SELECT *

                 FROM Customers;

             

            STORE Customers INTO $(vPathName) Customers.qvd;

            Drop Table Customers;

              • Re: QVD
                Anand Chouhan

                Syntax for QVD creation is with STORE command and syntax is

                 

                STORE TableName into TableName.qvd;

                 

                Ex1:-

                Tab1:

                LOAD * Inline

                [

                COlA

                a

                b

                ];

                 

                STORE Tab1 into Tab1.qvd;

                 

                 

                Ex2:-

                Let vRawQvdPath = 'C:\YourFolder\Data\App_QVD';

                 

                Tab1:

                LOAD * Inline

                [

                COlA

                a

                b

                ];

                 

                STORE Tab1 into $(vRawQvdPath)\Tab1.qvd;

              • Re: QVD
                Nils Morris

                If this is what you were looking for please mark as answered.