3 Replies Latest reply: Aug 7, 2013 8:36 AM by Henric Cronström RSS

    Syntax error, missing/misplaced FROM

      Friends, do not know what happens in this case. I tried several ways and always presents the same error. What can this be?

       

      Syntax error, missing/misplaced FROM: LIMITECLIENTE: LOAD ACCOUNTNUM AS[Código do Cliente], CREDITMAX AS [Limite Total], ATUAL AS [Limite Atual] LIMITECLIENTE: LOAD ACCOUNTNUM AS[Código do Cliente], CREDITMAX AS [Limite Total], ATUAL AS [Limite Atual]

       

      Below is the code that I created.

      LIMITECLIENTE:
      LOAD
      ACCOUNTNUM AS[Código do Cliente],
      CREDITMAX AS [Limite Total],
      ATUAL AS [Limite Atual];
      
      
      SELECT 
      CUSTTABLE.ACCOUNTNUM, 
      CUSTTABLE.CREDITMAX,
      (CUSTTABLE.CREDITMAX - ISNULL((SELECT SUM (TMPCRE.VALOR) FROM AX501_SRL_PROD2.dbo.TMPCRE  WHERE TMPCRE.ACCOUNT = CUSTTABLE.ACCOUNTNUM AND TMPCRE.STATUS = 'ABERTO'),0))ATUAL
      FROM AX501_SRL_PROD2.dbo.CUSTTABLE;
      STORE LIMITECLIENTE INTO [C:\QLIKVIEW\QlikView - Projetos\Dados\LIMITECLIENTE.QVD];
      DROP TABLE LIMITECLIENTE