3 Replies Latest reply on May 17, 2011 11:34 PM by scric88

    [FileMaker] [FileMaker] Invalid descriptor index

    scric88

      Title

      [FileMaker] [FileMaker] Invalid descriptor index

      Post

      Hello,

      I've to fill some sheet in Microsoft Excel so:

      -I've activate the ODBC connection in my project FileMaker;

      -I've import data in Microsoft Excel with Microsoft Query, but when MS Query return data I've the following error.

       --- --- --- [FileMaker][FileMaker] Invalid descriptor index --- --- ---

       

      Practically when I create a query with two parameters or more, I've the error.

      For Example:

      SELECT s.ruolo, s.nome

      FROM Settore s

      WHERE s.ruolo = ?

      AND s.nome = ?

      give me the error, instead:

      SELECT s.ruolo

      FROM Settore s

      WHERE s.ruolo = ?

      return data correctly.

      To note that in MS Query it's all ok, but when I return data to MS Excel appears error.

      I'm using:

      - FileMaker Pro 11.0v1

      - Microsoft Excel 2007

      - Microsoft Query (12.0.6423.1000) SP2 MSO (12.0.6554.5001)

      - Windows Vista Business SP2

      Thank you,

      Mattia

      errore.jpg