1 Reply Latest reply on Sep 8, 2014 1:07 PM by TSGal

    SQL create table statement with repeating fields



      SQL create table statement with repeating fields


      FileMaker Pro



      Operating system version

      OSX 10.9.4

      Description of the issue

      quote from fm13_sql_reference.pdf, page 20.
      create table statement.
      You specify a field repetition by using a number in square brackets. For example: lastDates[4].

      This does not work. Is it a bug or am I doing something wrong? If so, please provide an example of the correct SQL syntax on how to create a repeating field using a CREATE TABLE statement. Thanks.

      Steps to reproduce the problem

      CREATE TABLE T1 (C1[2] VARCHAR, C2 VARCHAR (50), C3 VARCHAR (1001),
      C4 VARCHAR (500276))

      Expected result

      table creation

      Actual result

      SQL error

      Exact text of any error message(s) that appear

      ERROR: FQL0001/(1:20): There is an error in the syntax of the query.