問題描述

我正在使用 flex 開發(fā)我的第一個桌面應(yīng)用程序，并且我也是第一次使用 sqlite.

I'm using flex to develop my first desktop app and I'm working with sqlite for the first time as well.

我正在創(chuàng)建我的數(shù)據(jù)庫和所有表，我還想將幾行數(shù)據(jù)添加到幾個表中，以便用戶在首次安裝時可以使用一些數(shù)據(jù).

I'm creating my database and all the tables and I would also like to add a few rows of data into a couple of the tables so that the users have some data to work with on first install.

我遇到的唯一問題是每次運(yùn)行程序時它都會一遍又一遍地插入相同的數(shù)據(jù).

The only problem I'm having is every time I run the program it keeps inserting the same data over and over again.

我只是想知道是否可以執(zhí)行 - INSERT INTO IF NOT EXISTS.或其他類型的工作.

I'm just wondering if its possible to do a - INSERT INTO IF NOT EXISTS. or some other kind of work around.

謝謝！

推薦答案

感謝您的洞察力，但我仍然沒有任何運(yùn)氣.

Thanks for the insight but I'm still not having any luck.

這是我的代碼

stmt.text = "CREATE TABLE IF NOT EXISTS tbl_breed ("+" breed_id INTEGER PRIMARY KEY AUTOINCREMENT, "+"  breed_breed TEXT)";
stmt.execute();
stmt.text = "INSERT OR IGNORE INTO tbl_breed (breed_breed)"+" VALUES ('Test')";
stmt.execute();

好的，我解決了這個問題 - 我猜你必須對主鍵進(jìn)行硬編碼，這就是我所做的

Ok so I fixed the problem - I guess you have to hard code primary key here's what i did

stmt.text = "CREATE TABLE IF NOT EXISTS tbl_breed ("+" breed_id INTEGER PRIMARY KEY AUTOINCREMENT, "+"  breed_breed TEXT)";
stmt.execute();
stmt.text = "INSERT OR IGNORE INTO tbl_breed (breed_id,breed_breed)"+" VALUES ('1','test')";
stmt.execute();

這篇關(guān)于sqlite &flex - 如果不存在則插入?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！