3 Replies Latest reply on Aug 6, 2012 9:30 AM by oliver

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

    intrepidbioscience

      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