AnsweredAssumed Answered

[FileMaker] [FileMaker] Invalid descriptor index

Question asked by scric88 on May 9, 2011
Latest reply on May 17, 2011 by scric88


[FileMaker] [FileMaker] Invalid descriptor index



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,