11-09-2015 5:04 AM
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
11-09-2015 5:26 AM
Hello Chandra,
there are several errors in your file:
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
11-09-2015 5:14 AM
Hi Chandra for the Amount value try Default value 0.00
Regards
Arden
11-09-2015 5:21 AM
11-09-2015 5:28 AM
Should there be a final comma after the last column you've entered?
11-09-2015 5:26 AM
Hello Chandra,
there are several errors in your file:
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