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

    SQL create table statement with repeating fields

    PeterWagemans

      Summary

      SQL create table statement with repeating fields

      Product

      FileMaker Pro

      Version

      13

      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.