> Thanks for idea - it really helped, even I can't understand what's the
> difference, because from SQL point of view my solution was correct.
>
The problem is that the QSQL module create the querys based in the thinking
that every table have is PK. Also, be carefull when using tables with equal
column names. If you do that, you need to specify the table like this:
model.setRelation(0, new QSqlRelation("employee", "Employee.id", "surname"));
Or you will have another strange behavior.
> Regards
>
> Dne Čt 20. května 2010 09:36:15 José Arcángel Salazar Delgado napsal(a):
> > > Dne Čt 20. května 2010 09:08:11 José Arcángel Salazar Delgado napsal(a):
> > > > > Hello,
> > > > > yes i though there could be query problem - but how can examine the
> > > > > query generated? I'm using postgresql.
> > > > >
> > > > > I have this model (simplified)
> > > > >
> > > > > CREATE TABLE Employee (
> > > > >
> > > > > id serial NOT NULL,
> > > > > name varchar(255) NOT NULL,
> > > > > surname varchar(255) NOT NULL,
> > > > > PRIMARY KEY (id));
> > > > >
> > > > > CREATE TABLE EduPlan (
> > > > >
> > > > > Employeeid int4 NOT NULL,
> > > > > "date" date NOT NULL,
> > > > >
> > > > > );
> > > > >
> > > > > I have the realtional model like this:
> > > > >
> > > > > model.setTable("eduplan");
> > > > > model.setRelation(0, new QSqlRelation("employee", "id",
> > > > > "surname"));
> > > > > model.setEditStrategy(QSqlTableModel.EditStrategy.OnFieldChange);
> > > > > ui.planTable.setItemDelegate(new QSqlRelationalDelegate());
> > > > > model.select();
> > > > >
> > > > > really simple - almost as the example
> > > >
> > > > I'm only guessing, but I thing the problem is that you don't have any
> > > > PK in the EduPlan Column. Can you try to add some id field to the
> > > > table and try again?
> > >
> > > Oh I forgot, there is a foreign key of course like this:
> > > ALTER TABLE EduPlan ADD CONSTRAINT plans FOREIGN KEY (Employeeid)
> > > REFERENCES Employee (id);
> > >
> > > or did you mean I shoould add separate primary key column?
> >
> > yes, I think that you need a separate PK for the table Eduplan, some
> > database do strage things if there is no PK in a table.
> >
> > try with something like:
> >
> > CREATE TABLE EduPlan (
> >
> > id serial NOT NULL,
> >
> > Employeeid int4 NOT NULL,
> > "date" date NOT NULL,
> >
> > PRIMARY KEY (id));
> >
> > > > > thanks
> > > > >
> > > > > Dne St 19. května 2010 17:05:00 José Arcángel Salazar Delgado
napsal(a):
> > > > > > > Hello,
> > > > > > > i'm trying to use relationalTableModel as described in doc and
> > > > > > > examples. Everything is pretty simple almost the same as in
> > > > > > > example. The model has OnFieldChange EditStrategy However i'm
> > > > > > > not able to change the relation column value nor delete the
> > > > > > > row.
> > > > > > >
> > > > > > > While updating the model.lastError() gives:
> > > > > > > QSqlError(0, "Unable to bind parameters", "The column index is
> > > > > > > out of range: 4, number of columns: 3. (22023)")
> > > > > > >
> > > > > > > which is strange because the table has 4 columns (including
> > > > > > > foreign key column)
> > > > > > >
> > > > > > > while deleting (using model.removeRows()) it gives:
> > > > > > > QSqlError(0, "Unable to execute query", "ERROR: column
> > > > > > > "surname" does not exist (42703)")
> > > > > > >
> > > > > > > the "surname" is displayColumn of QSqlRelation :(
> > > > > >
> > > > > > This normaly happend when your query is wrong. What Database are
> > > > > > you using? This happend to me when I forgot to add the table
> > > > > > name to the parameters or the schema name.
> > > > > >
> > > > > > If you can give us more information we could help you.
> > > > > >
> > > > > > > Please can someone give me an advice what could be wrong, or
> > > > > > > how to investigate the problem deeply (for instance how to
> > > > > > > debug into code).
> > > > > > >
> > > > > > > Using 4.5.2_01 still because the newest distro for linux
> > > > > > > doesn't contain a designer binary ;-)
> > > > > > >
> > > > > > > Regards
> > > > > > >
> > > > > > > Jiri Mikulasek
> > > > > > >
> > > > > > > AURA, s.r.o. Czech Republic
> > > > > > > _______________________________________________
> > > > > > > Qt-jambi-interest mailing list
> > > > > > > [email protected]
> > > > > > > http://lists.trolltech.com/mailman/listinfo/qt-jambi-interest
> > > > >
> > > > > _______________________________________________
> > > > > Qt-jambi-interest mailing list
> > > > > [email protected]
> > > > > http://lists.trolltech.com/mailman/listinfo/qt-jambi-interest
> > >
> > > _______________________________________________
> > > Qt-jambi-interest mailing list
> > > [email protected]
> > > http://lists.trolltech.com/mailman/listinfo/qt-jambi-interest
>
> _______________________________________________
> Qt-jambi-interest mailing list
> [email protected]
> http://lists.trolltech.com/mailman/listinfo/qt-jambi-interest
--
Ing. José Arcángel Salazar Delgado
Nettrace
Av 27 #6 col. Venustiano Carranza.
Boca del río, Ver.
Tel. Oficina 9-27-54-78
_______________________________________________
Qt-jambi-interest mailing list
[email protected]
http://lists.trolltech.com/mailman/listinfo/qt-jambi-interest
