Hello
I am trying to use the Master/details view to allow multiple files related to a single document.
I took the documentation as guide and the ERP demo but I always get an SQL error in the Master View.
Error: during query execution. SELECT "saving_files"."id_saving_file", "saving_files"."id_saving", "savings____1"."id_saving" AS "savings____id_saving____1" FROM "saving_files" LEFT JOIN "savings" AS "savings____1" ON "saving_files"."id_saving" = "savings____1"."id_saving" WHERE "saving_files"."id_saving" = '5' ORDER BY "saving_files"."id_saving_file" desc, "saving_files"."id_saving_file" OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY
The DBMS server said: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]A column has been specified more than once in the order by list. Columns in the order by list must be unique.
I read that in a previous version of DadaBik there was a similar error.
In the details table the field: id_saving_file has following attributes:
Field name: id_saving_file
Field type: int
Nullable: No
PK index: Primary Key
Extra: identity
Is this a know error?
Is the Master/Details View supported for SQL Server?
Thanks.
Regards
Vanessa
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
You are using DaDaBIK version 10.6-Manarola enterprise, installed on 02-01-2021 (installation code: 163795fe08c2c792c5), the latest version of DaDaBIK is 10.6-Manarola released on 01-26-2021
You are runnning the latest release of DaDaBIK
In case you want to upgrade to a more powerful edition (from Pro to Enterprise/Platinum, from Enteprise to Platinum) please contact us.
System info
PHP Version: 7.3.13
sqlserver version: 14.00.3192
Web server: Microsoft-IIS/10.0
Client: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36
URL installation: https://localhost\/
I am trying to use the Master/details view to allow multiple files related to a single document.
I took the documentation as guide and the ERP demo but I always get an SQL error in the Master View.
Error: during query execution. SELECT "saving_files"."id_saving_file", "saving_files"."id_saving", "savings____1"."id_saving" AS "savings____id_saving____1" FROM "saving_files" LEFT JOIN "savings" AS "savings____1" ON "saving_files"."id_saving" = "savings____1"."id_saving" WHERE "saving_files"."id_saving" = '5' ORDER BY "saving_files"."id_saving_file" desc, "saving_files"."id_saving_file" OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY
The DBMS server said: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]A column has been specified more than once in the order by list. Columns in the order by list must be unique.
I read that in a previous version of DadaBik there was a similar error.
In the details table the field: id_saving_file has following attributes:
Field name: id_saving_file
Field type: int
Nullable: No
PK index: Primary Key
Extra: identity
Is this a know error?
Is the Master/Details View supported for SQL Server?
Thanks.
Regards
Vanessa
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
You are using DaDaBIK version 10.6-Manarola enterprise, installed on 02-01-2021 (installation code: 163795fe08c2c792c5), the latest version of DaDaBIK is 10.6-Manarola released on 01-26-2021
You are runnning the latest release of DaDaBIK
In case you want to upgrade to a more powerful edition (from Pro to Enterprise/Platinum, from Enteprise to Platinum) please contact us.
System info
PHP Version: 7.3.13
sqlserver version: 14.00.3192
Web server: Microsoft-IIS/10.0
Client: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36
URL installation: https://localhost\/