Dynamic SQL generation for SelectCommand fails

Dynamic SQL generation for SelectCommand fails

Postby chris901 » 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"

Image

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/postgresql-sample-database/

I installed the database like this:
http://www.postgresqltutorial.com/load-postgresql-sample-database/

The query SelectCommand:
Code: Select all
select * from actor;
chris901
 
Posts: 64
Joined: Wed 20 Jul 2016 04:21

Re: Dynamic SQL generation for SelectCommand fails

Postby Pinturiccio » Tue 11 Oct 2016 13:22

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.
Pinturiccio
Devart Team
 
Posts: 1983
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for PostgreSQL