Results 1 to 3 of 3

Thread: how to clear relationship

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #3
    Join Date
    Jul 2015
    Posts
    3
    Qt products
    Qt5
    Platforms
    Windows

    Default Re: how to clear relationship

    Thanks ChrisW67 for reply.

    I'm sorry for my English, maybe that is why we did not understand.
    I do not need to delete primary key, but foreign keys ( FK in table driver, as the driver can be free of car ).
    Definitions of table "DRIVER" : CREATE TABLE "driver" ("ID" INTEGER PRIMARY KEY NOT NULL , "NAME" TEXT, "CAR" INTEGER)
    where column "CAR" contain foreign key from table "CARS".
    LastError() does not contain any errors.
    I have to allow the driver to remove car, so delete the primary key, so delete relationship.

    If create a new entry in table driver, does not fill a column CAR, write by
    " rtblmdl->setRecord(ui->tblW->currentIndex().row(),rec);
    rtblmdl->submitAll();"

    ended without error, and column CAR containing NULL.

    If create a new entry in table driver, with fill a column CAR (FK from table CARS), without error. But if i need delete this FK, write by
    " rtblmdl->setRecord(ui->tblW->currentIndex().row(),rec);
    rtblmdl->submitAll();"
    ended without error, but FK don't delete.

    Milos.
    Last edited by milos1; 28th July 2015 at 06:16.

Similar Threads

  1. Facebook Relationship Visualization
    By Sven in forum Qt-based Software
    Replies: 3
    Last Post: 10th November 2014, 13:26
  2. what's the relationship between QOCI and OCI ?
    By silentyears in forum Qt Programming
    Replies: 6
    Last Post: 14th March 2014, 13:29
  3. Replies: 1
    Last Post: 18th April 2012, 16:35
  4. How to get the relationship between two QDockWidget?
    By yunxiaodong in forum Qt Programming
    Replies: 0
    Last Post: 16th August 2011, 08:32
  5. Relationship b/w different classes
    By salmanmanekia in forum Newbie
    Replies: 0
    Last Post: 2nd June 2010, 18:24

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Qt is a trademark of The Qt Company.