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?
> > 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
