5 Replies Latest reply: Mar 14, 2011 2:58 PM by Pablo Gálvez RSS

    syntax errror

    abauman23

       

      Why am I getting this error?

       

      Field not found - <TotalCost>

      ITEMLOC:

      Load

      VersionNum,

      ItemNumLoc,

      LocationNum,

      DescriptionLoc,

      PiecesOnHand,

      TotalCost as TotalCostLoc

      From q:\abauman\qlikview_qvd\youarehereab.qvd

      (qvd)

       

       

      and then also this error:

       

      ODBC connection failed
      ITEMLOC:
      SQL SELECT *

      FROM TTM.ITEMLOC

        • syntax errror
          Manesh KHOT

          Hi,

          Please explain ur issue in details. What time u r getting this error?

          • syntax errror
            abauman23

            Thanks for your help, but i think i figured out the issue.

            Thanks

            Adam

            • syntax errror
              Pablo Gálvez

              ITEMLOC:

              Load

              VersionNum,

              ItemNumLoc,

              LocationNum,

              DescriptionLoc,

              PiecesOnHand,

              TotalCost as TotalCostLoc

              From q:\abauman\qlikview_qvd\youarehereab.qvd

              (qvd);

               

              You missed the semicolon, I think. You must close each sentece or line that you've charged or created.

               

              Make sure that the Database is in the right folder. Maybe the database was moved to another direction.

               

               

               

               

               

               

               

               

              • syntax errror
                s j

                if there is space between totalcost then place brackert

                  • syntax errror
                    Pablo Gálvez

                    ITEMLOC:

                    Load

                    VersionNum,

                    ItemNumLoc,

                    LocationNum,

                    DescriptionLoc,

                    PiecesOnHand,

                    TotalCost as TotalCostLoc

                    From q:\abauman\qlikview_qvd\youarehereab.qvd

                    (qvd);

                     

                    You missed the semicolon, I think. You must close each sentece or line that you've charged or created.

                     

                    Make sure that the Database is in the right folder. Maybe the database was moved to another direction.