Development/Tutorials/SqLite - Revision history

Tstaerk: /* Analyze it */

2011-12-17T13:34:41Z

‎Analyze it

2011-12-17T13:33:40Z

‎Run it

2011-12-17T09:56:14Z

‎See also

2011-12-17T09:43:29Z

‎sqlite.pro

2011-11-10T10:03:34Z

‎See also

2011-11-10T09:55:27Z

2011-11-10T09:55:10Z

2011-11-10T09:46:20Z

2011-11-10T09:25:11Z

2011-11-10T09:23:52Z

Created page with "= See also = http://doc.trolltech.com/4.5/sql-relationaltablemodel.html"

New page

= See also =
http://doc.trolltech.com/4.5/sql-relationaltablemodel.html

@@ Line 60: / Line 60: @@
   sqlite> .schema stocks
   CREATE TABLE stocks(id int primary key, name varchar(20));
 = See also =

@@ Line 51: / Line 51: @@
   ll /root/sqlite.dat
   -rw-r--r-- 1 root root 3072 Nov 10 10:37 /root/sqlite.dat
 = See also =

@@ Line 53: / Line 53: @@
 = See also =
 * http://doc.trolltech.com/4.5/sql-relationaltablemodel.html
 * http://commits.kde.org/kdeexamples/23d2202b0e7aca8999928374746da5733712ebc8

@@ Line 35: / Line 35: @@
-SOURCES += main.cpp\
+SOURCES += main.cpp
-        mainwindow.cpp
 </pre>

@@ Line 57: / Line 57: @@
 = See also =
-http://doc.trolltech.com/4.5/sql-relationaltablemodel.html
+* http://doc.trolltech.com/4.5/sql-relationaltablemodel.html
-http://commits.kde.org/kdeexamples/23d2202b0e7aca8999928374746da5733712ebc8
+* http://commits.kde.org/kdeexamples/23d2202b0e7aca8999928374746da5733712ebc8

← Older revision		Revision as of 09:55, 10 November 2011
Line 1:		Line 1:
		+	= Overview =
	SqLite allows you to store data in a file and query this data using SQL just as you would do with a database server. As an example if you want to manage your stock transactions selecting all buy transactions from a flat file is tedious. Using sqlite you can just issue something like		SqLite allows you to store data in a file and query this data using SQL just as you would do with a database server. As an example if you want to manage your stock transactions selecting all buy transactions from a flat file is tedious. Using sqlite you can just issue something like
	select * from transactions where type='buy'		select * from transactions where type='buy'

@@ Line 1: / Line 1: @@
 <pre>
 #include <QtSql>
@@ Line 19: / Line 26: @@
 </pre>
 <pre>
 QT       += core gui sql
@@ Line 33: / Line 41: @@
 FORMS    += mainwindow.ui
 </pre>
 = See also =
 http://doc.trolltech.com/4.5/sql-relationaltablemodel.html
 http://commits.kde.org/kdeexamples/23d2202b0e7aca8999928374746da5733712ebc8

← Older revision		Revision as of 09:25, 10 November 2011
Line 1:		Line 1:
		+	<pre>
		+	QT += core gui sql
		+
		+	TARGET = sqlite
		+	TEMPLATE = app
		+
		+
		+	SOURCES += main.cpp\
		+	mainwindow.cpp
		+
		+	HEADERS += mainwindow.h
		+
		+	FORMS += mainwindow.ui
		+	</pre>
		+
	= See also =		= See also =
	http://doc.trolltech.com/4.5/sql-relationaltablemodel.html		http://doc.trolltech.com/4.5/sql-relationaltablemodel.html