AnsweredAssumed Answered

SQL create table statement with repeating fields

Question asked by PeterWagemans on Sep 8, 2014
Latest reply on Sep 8, 2014 by TSGal

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.

Outcomes