Databases
StackOverflow2013
Postsdbo
POcreating a foreign key in sqlite database
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POcreating a foreign key in sqlite database
    primarykey
    data
    text
    <p>i need to create a foreign key to map my tables. Basically this foreign is a primary key of a table. but the insert statement is creting an issue. Its an SQLite database. the table with the primary key is</p> <pre><code>db.execSQL("CREATE TABLE IF NOT EXISTS " + Main + "(ROWID integer primary key autoincrement NOT NULL,appln_date VARCHAR,appln_no VARCHAR,rupees VARCHAR,tenure VARCHAR,asset VARCHAR);"); </code></pre> <p>the table with the foreign key is </p> <pre><code>db.execSQL("CREATE TABLE IF NOT EXISTS " + Applicant + "(AppID integer primary key autoincrement, " + "app_salutation VARCHAR,app_fname VARCHAR,app_mname VARCHAR,app_lname VARCHAR,app_door VARCHAR,app_street VARCHAR,app_building VARCHAR,app_area VARCHAR,app_post VARCHAR,app_tehsil VARCHAR,app_state VARCHAR,app_landmark VARCHAR,ROWID integer References "+Main+"(ROWID));"); </code></pre> <p>the insert statement is </p> <pre><code>openOrCreateDatabase(); createappinfo(); String insertString = "insert into " + Applicant + " Values("; String inString = ""; for (int i =0; i &lt; data.size(); i++) { inString = inString + "\"" + data.get(i) + "\","; } inString = inString.substring(0, inString.length() - 1); int row=db.rawQuery("select * from "+Main+";" ,null).getCount()+1; insertString = insertString + row+"," +inString + ");"; System.out.println("** insert value ** " + insertString); db.execSQL(insertString); closeDatabase(); </code></pre> <p>but this code is generating an error..</p> <pre><code>04-25 11:43:57.422: E/SQLiteLog(17825): (1) table applicanttable has 14 columns but 13 values were supplied </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USshivani
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COYour error code says that you supply only 13 values instead of 14. Check again that you're providing values for all the columns with `data`
      singulars
      1. POcreating a foreign key in sqlite database
      1. USBigood
    2. CO@Bigood the first is an autoincrement field then 12 columns are filled through the above code and then theres a foreign key...so the first and the last feild values are not to be passed the...wats the error..i can seem to figure it out
      singulars
      1. POcreating a foreign key in sqlite database
      1. USshivani
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload