Results 1 to 8 of 8

Thread: Can't create table

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Mar 2006
    Posts
    10
    Thanked 7 Times in 6 Posts
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default Re: Can't create table

    Use command line sqlite or check for any error after creating table.
    Enter SQL statements terminated with a ";"
    sqlite> CREATE table stnInfo (id int recNum primary key, call varchar(8), name varchar(80), addr
    ess1 varchar(80), accress2 varchar(80), city varchar(80), state varchar(80), state varchar(40),
    postalCode varchar(20), country varchar(40), grid varchar(8), cqZone varchar(8), ituZone varchar
    (8), latitude varchar(8), longitude varchar(8), licenseClass varchar(12));
    SQL error: duplicate column name: state
    sqlite>

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

    waynew (30th October 2009)

  3. #2
    Join Date
    May 2009
    Location
    USA
    Posts
    300
    Thanks
    82
    Thanked 11 Times in 11 Posts
    Qt products
    Qt4
    Platforms
    Windows

    Default Re: Can't create table

    Thanks Rembobo, my eyes must be getting bad. Typos are the pits.
    Works fine now.

Similar Threads

  1. Postgresql QSqlRelationalTableModel empty table
    By RolandHughes in forum Qt Programming
    Replies: 0
    Last Post: 12th November 2008, 17:18
  2. How create a two level table?
    By kaushal_gaurav in forum Qt Programming
    Replies: 3
    Last Post: 29th October 2008, 18:16
  3. Replies: 3
    Last Post: 5th October 2008, 23:41
  4. displaying any table on a qdatatable
    By Philip_Anselmo in forum Newbie
    Replies: 4
    Last Post: 9th May 2006, 22:12
  5. creating table plugin
    By mgurbuz in forum Qt Programming
    Replies: 3
    Last Post: 28th April 2006, 13:50

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.