Unable to activate a table

[former_member226239]

Hi All,

I am getting the Parse error for table definition when I try to activate the database table. Here is the full error text: "Repository: CheckObjects failed for at least one object; Parse error for table definition: Syntax error: Extension are only allowed with the list itself.; row: 5 column: 0"

Here is the code that I have.....

table.schemaName = "cs_first";

table.tableType = COLUMNSTORE;

table.description = "Workshop order Header";

table.columns = {

{ name = "OrderId"; sqlType = NVARCHAR; nullable = false; length = 10;   },

{ name = "CreatedBy"; sqlType = NVARCHAR; nullable = false; length = 10; },

{ name = "CreatedAt"; sqlType = DATE; nullable = false;                  },

{ name = "Currency"; sqlType = NVARCHAR; nullable = false; length = 5;   },

{ name = "GrossAmount"; sqlType = DECIMAL; nullable = false; precision = 15; scale = 2; defaultValue = "0";  },

};

table.primarykey.pkcolumns = ["OrderId"];

Thank you in advance,

Chandra

[Former Member]

Hi Chandra for the Amount value try Default value 0.00

Regards

Arden

[former_member226239]

No use, same error.

[Former Member]

Should there be a final comma after the last column you've entered?

[pfefferf]

Hello Chandra,

there are several errors in your file:

• the list of table.columns has to be enclosed in square brackets, not in curly brackets
• the comma after the last column (GrossAmount) is not right
• table.primarkey is not right, it is called table.primaryKey

Here is the corrected syntax:

table.schemaName = "cs_first";
table.tableType = COLUMNSTORE;
table.description = "Workshop order Header";
table.columns = [
{ name = "OrderId"; sqlType = NVARCHAR; nullable = false; length = 10;   },
{ name = "CreatedBy"; sqlType = NVARCHAR; nullable = false; length = 10; },
{ name = "CreatedAt"; sqlType = DATE; nullable = false;                  },
{ name = "Currency"; sqlType = NVARCHAR; nullable = false; length = 5;   },
{ name = "GrossAmount"; sqlType = DECIMAL; nullable = false; precision = 15; scale = 2; defaultValue = "0";  }
];
table.primaryKey.pkcolumns = ["OrderId"];

Please check also if your schema "cs_first" is really written in lower case.

Best Regards,

Florian