AnsweredAssumed Answered

CAST(Company_Brochures AS VARCHAR(NNN))  error in the syntax of the query

Question asked by intrepidbioscience on Feb 14, 2012
Latest reply on Aug 6, 2012 by oliver

Title

CAST(Company_Brochures AS VARCHAR(NNN))  error in the syntax of the query

Post

select CAST(antigenicIndex AS VARCHAR(NNN)) from geneclone where productionID=01234

I use Java API connect to Filemaker pro .Query as above , get a error :

com.filemaker.jdbc.FMSQLException: [FileMaker][FileMaker JDBC] FQL0001/(1:39): There is an error in the syntax of the query.
No warnings 

I can not understand   what the NNN stand for ?Just a rename of 'antigeneicIndex' Or a format words in the query .

What is wrong with the query string 

Outcomes