Dynamic SQL generation for SelectCommand fails
Posted: Sun 09 Oct 2016 16:57
PostgreSQL 9.5 and latest dotConnect Version installed.
When I try to generate Insert, Update and Delete Commands for the PgSqlDataTable using the Command Generator I get the following error:
Roughly translated: "Dynamic SQL generation is not supported for SelectCommand because it doesn't return base table informations"
When I searched for this error I found that this can be caused by not having a primary key in the table. However I do have a PK and it is also part of the query I am using in the SelectCommand.
I am using this database:
http://www.postgresqltutorial.com/postg ... -database/
I installed the database like this:
http://www.postgresqltutorial.com/load- ... -database/
The query SelectCommand:
When I try to generate Insert, Update and Delete Commands for the PgSqlDataTable using the Command Generator I get the following error:
Roughly translated: "Dynamic SQL generation is not supported for SelectCommand because it doesn't return base table informations"
When I searched for this error I found that this can be caused by not having a primary key in the table. However I do have a PK and it is also part of the query I am using in the SelectCommand.
I am using this database:
http://www.postgresqltutorial.com/postg ... -database/
I installed the database like this:
http://www.postgresqltutorial.com/load- ... -database/
The query SelectCommand:
Code: Select all
select * from actor;