Devart Forums

Hello,

I am using this database:
http://www.postgresqltutorial.com/postg ... -database/

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


I want to build a master-detail relation like this:

Master PgSqlDataTable: http://i.imgur.com/uQzryF9.png

Detail PgSqlDataTable: http://i.imgur.com/rZKPBxl.png

Setup of the Relation: http://i.imgur.com/u2RTZ6q.png

When I now want to CreateColumns on the Child Table I get the following error: http://i.imgur.com/1Z13fjw.png

I am not 100% but I think I got this working with a previous version of dotConnect.
I know that I once got master-detail-realtion working. What is wrong here?

The master-detail relation can be used only for tables that have a relation between them on the server side. For example if a parent table will have a select query like "select * from film" and a child table will have a select query like "select * from film_actor", you can configure a master-detail relation between such tables, and CreateColumns won't throw the error.

I just found the reason for this bug. This took me some days to figure out.

If you use a in your child table select statement at the end the WHERE error gets thrown.

When you remove the symbol the error won't appear. Could you please fix this?


E.g:

Works:
Error:

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

Just noticed this also happens if there is a commented line at the end of the statement

E.g: Then it throws "cannot establish master/detail relation" error.

We have fixed the bug with creating columns for a child table in a master-detail relation when a select command in the child table ends with a semicolon. We will post here when the corresponding build of dotConnect for PostgreSQL is available for download.

chris901 wrote:Just noticed this also happens if there is a commented line at the end of the statement

This is the designed behaviour. dotConnect for PostgreSQL does not support commented lines in a child select query. Supporting them would require syntax parsing of select statements, which would reduce performance.

New version of dotConnect for PostgreSQL 7.7 is released!
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=34690