Results 1 to 3 of 3

Thread: Implementation help (database application)

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Dec 2009
    Location
    Brisbane
    Posts
    17
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows
    Thanked 3 Times in 3 Posts

    Default Re: Implementation help (database application)

    http://www.sqlite.org/lang_attach.html

    The above should help. Rather than replacing the database, have a set of tables that are the core information. either, use them attached, or attach your update database, get rid of the old info, and replace it from the new database.

    so, for example, if you attach the database as "updates", you can then "insert into infotable select * from updates.infotable"

    Hope this helps.

  2. The following user says thank you to tangential for this useful post:

    jiveaxe (5th February 2010)

  3. #2
    Join Date
    Aug 2007
    Posts
    244
    Qt products
    Qt4
    Platforms
    Unix/X11
    Thanks
    42
    Thanked 8 Times in 8 Posts

    Default Re: Implementation help (database application)

    Very thanks tangential,
    your solution is great and simple; I've tried it in the console for now, but it should work with qt. Only an updates to your query:

    insert or replace into infotable select * from updates.infotable

    This for avoid the unique primary key error.

    Regards
    Giuseppe CalÃ

Similar Threads

  1. Replies: 3
    Last Post: 9th February 2011, 21:30
  2. Replies: 10
    Last Post: 23rd July 2009, 00:52
  3. Replies: 2
    Last Post: 17th April 2009, 23:36
  4. Run database application from Konqueror
    By jiveaxe in forum Newbie
    Replies: 3
    Last Post: 17th October 2007, 18:54
  5. My application can't connect to database when deploy it???
    By gtthang in forum Installation and Deployment
    Replies: 1
    Last Post: 15th February 2006, 12:01

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.