Hello,
I have created a new field called DimensionNames in table extension LedgerTrialBalanceTmp.
This field is an extended data type of DimensionSetSegmentName.
It is similar to DimensionValue field this table already has.
Now while updating the recordset for this table, system at runtime is not able to understand that this is an array.
I have below statement written in my extension code
----------------------------------------------------------------
update_recordset ledgerTrialBalanceTmp setting
DimensionNames[1] = somevalue1,
....
...
DimensionName[11]= somevalue11
where ledgerTrialBalanceTmp.ledgerdimension = somevalue;
------------------------------------------------------------------
While executing this code, I am getting error
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The column name 'DIMENSIONNAMES' is specified more than once in the SET clause or column list of an INSERT. A column cannot be assigned more than one value in the same clause. Modify the clause to make sure that a column is updated only once. If this statement updates or inserts columns into a view, column aliasing can conceal the duplication in your code.
This kind of update_recordset works for the same table for DimensionValue field in method Classes->LedgerTrialBalanceDP->updateSummaryMainFocusDescriptions
Can anyone please help me know what's the issue with an array here? I already build application suite model with my custom model and db synchronization. but no help.
