SQLdb Tutorial1: Revision history

27 February 2020

• curprev 00:5500:55, 27 February 2020‎ Trev talk contribs‎ m 13,295 bytes +36‎ Fixed syntax highlighting; deleted category included in page template

2 March 2017

• curprev 13:0213:02, 2 March 2017‎ Arent talk contribs‎ 13,259 bytes −4‎ →‎Project and components
• curprev 13:0213:02, 2 March 2017‎ Arent talk contribs‎ 13,263 bytes +5‎ →‎Project and components
• curprev 12:5912:59, 2 March 2017‎ Arent talk contribs‎ 13,258 bytes 0‎ →‎Project and components
• curprev 12:5812:58, 2 March 2017‎ Arent talk contribs‎ 13,258 bytes −12‎ →‎Basic example

15 August 2016

• curprev 12:1412:14, 15 August 2016‎ Arent talk contribs‎ 13,270 bytes +22‎ No edit summary

17 October 2015

• curprev 12:4512:45, 17 October 2015‎ Kapibara talk contribs‎ 13,248 bytes +139‎ →‎Choosing what data to show

15 July 2015

• curprev 23:1523:15, 15 July 2015‎ FTurtle talk contribs‎ 13,109 bytes +1‎ No edit summary

10 May 2015

• curprev 16:4316:43, 10 May 2015‎ Socke talk contribs‎ m 13,108 bytes 0‎ →‎Connecting to the database: fixed broken link

11 March 2014

• curprev 10:2910:29, 11 March 2014‎ BigChimp talk contribs‎ 13,108 bytes +32‎ →‎Project and components: image

12 December 2013

• curprev 18:2018:20, 12 December 2013‎ Bartlebee talk contribs‎ 13,076 bytes −13‎ Undo revision 73555 by Bartlebee (talk) I realize I was incorrect

22 November 2013

• curprev 03:3603:36, 22 November 2013‎ BigChimp talk contribs‎ m 13,089 bytes +94‎ No edit summary
• curprev 03:1303:13, 22 November 2013‎ BigChimp talk contribs‎ m 12,995 bytes +102‎ →‎See also
• curprev 03:1203:12, 22 November 2013‎ BigChimp talk contribs‎ 12,893 bytes −10,862‎ moved install instructions to tutorial0

17 October 2013

• curprev 20:4920:49, 17 October 2013‎ Bartlebee talk contribs‎ 23,755 bytes +13‎ →‎SQLite: A regular name does not work. Needs the entire path.
• curprev 18:3618:36, 17 October 2013‎ Bartlebee talk contribs‎ m 23,742 bytes +77‎ corrected typo. Added small comment for sqlite

9 May 2013

• curprev 23:0223:02, 9 May 2013‎ Bertman talk contribs‎ m 23,665 bytes −7‎ Changed customer and employee data statements to make the SQL-statements work when copied

13 January 2013

• curprev 19:2619:26, 13 January 2013‎ BigChimp talk contribs‎ 23,672 bytes +89‎ →‎PostgreSQL: layout, clarificaton on insert statements
• curprev 19:2319:23, 13 January 2013‎ BigChimp talk contribs‎ m 23,583 bytes +49‎ →‎SQLite
• curprev 19:2319:23, 13 January 2013‎ BigChimp talk contribs‎ m 23,534 bytes +1‎ →‎SQLite

21 December 2012

• curprev 11:1911:19, 21 December 2012‎ BigChimp talk contribs‎ 23,533 bytes +124‎ Database dlls should be in Lazarus directory, not project directory

4 December 2012

• curprev 15:1915:19, 4 December 2012‎ Tangentstorm talk contribs‎ m 23,409 bytes +42‎ →‎Firebird database libraries on Windows

18 November 2012

• curprev 10:2510:25, 18 November 2012‎ BigChimp talk contribs‎ 23,367 bytes +62‎ →‎Choosing what data to show: button caption
• curprev 10:1010:10, 18 November 2012‎ BigChimp talk contribs‎ 23,305 bytes +252‎ →‎Connecting to the database
• curprev 10:0410:04, 18 November 2012‎ BigChimp talk contribs‎ m 23,053 bytes +3‎ →‎Link the components
• curprev 10:0210:02, 18 November 2012‎ BigChimp talk contribs‎ 23,050 bytes +76‎ Indicate postgresql and sqlite already catered for; clarify windows lib instructions
• curprev 09:5709:57, 18 November 2012‎ BigChimp talk contribs‎ m 22,974 bytes −20‎ →‎Firebird database libraries on other systems
• curprev 09:5509:55, 18 November 2012‎ BigChimp talk contribs‎ 22,994 bytes +147‎ Installation on Linux: update with -dev library

15 November 2012

• curprev 20:2220:22, 15 November 2012‎ BigChimp talk contribs‎ m 22,847 bytes −4‎ →‎No Firebird or employee.fdb installed?
• curprev 20:2120:21, 15 November 2012‎ BigChimp talk contribs‎ 22,851 bytes +1,452‎ Added employee example ready for sqldbtutorial3
• curprev 19:5319:53, 15 November 2012‎ BigChimp talk contribs‎ 21,399 bytes −129‎ Undo revision 63973 by BigChimp (talk)
• curprev 19:5119:51, 15 November 2012‎ BigChimp talk contribs‎ 21,528 bytes +129‎ Added salary column used in sqldb tutorial3

14 November 2012

• curprev 11:4411:44, 14 November 2012‎ BigChimp talk contribs‎ m 21,399 bytes +200‎ Links to tutorial3, cosmetic copy/paste error fixed

7 November 2012

• curprev 17:1817:18, 7 November 2012‎ Cuniculophile talk contribs‎ m 21,199 bytes 0‎ moved SQLdb Tutorial1 (Français) to SQLdb Tutorial1 over redirect
• curprev 17:1817:18, 7 November 2012‎ Cuniculophile talk contribs‎ m 21,199 bytes 0‎ moved SQLdb Tutorial1 to SQLdb Tutorial1 (Français): Je n'ai pas trouvé comment signifier qu'il s'agissait d'une traduction

25 September 2012

• curprev 07:5007:50, 25 September 2012‎ Chronos talk contribs‎ 21,199 bytes 0‎ fixed link

15 September 2012

• curprev 19:3819:38, 15 September 2012‎ BigChimp talk contribs‎ 21,199 bytes −23‎ remove superfluous SQLQuery1.clear
• curprev 09:1509:15, 15 September 2012‎ BigChimp talk contribs‎ m 21,222 bytes −2‎ No edit summary
• curprev 09:1509:15, 15 September 2012‎ BigChimp talk contribs‎ 21,224 bytes −21,566‎ Split up sql db tutorial for brevity/apparent complexity

14 September 2012

• curprev 17:1617:16, 14 September 2012‎ BigChimp talk contribs‎ 42,790 bytes +113‎ →‎PostgreSQL: Added serial cust_no instead of regular insert. This should let inserts work.
• curprev 17:1417:14, 14 September 2012‎ BigChimp talk contribs‎ m 42,677 bytes −39‎ →‎No Firebird or employee.fdb installed?: Change cust no to match postgresql serial datatype
• curprev 17:1217:12, 14 September 2012‎ BigChimp talk contribs‎ m 42,716 bytes −9‎ →‎No Firebird or employee.fdb installed?: Stay within VARCHAR(25)
• curprev 16:5716:57, 14 September 2012‎ BigChimp talk contribs‎ 42,725 bytes +154‎ →‎PostgreSQL
• curprev 16:5616:56, 14 September 2012‎ BigChimp talk contribs‎ 42,571 bytes +61‎ →‎See also
• curprev 16:5116:51, 14 September 2012‎ BigChimp talk contribs‎ 42,510 bytes +81‎ →‎SQLite, other database
• curprev 16:4716:47, 14 September 2012‎ BigChimp talk contribs‎ m 42,429 bytes +1‎ →‎= PostgreSQL
• curprev 16:4616:46, 14 September 2012‎ BigChimp talk contribs‎ 42,428 bytes +295‎ →‎Connecting to the database: postgresql notes
• curprev 16:4216:42, 14 September 2012‎ BigChimp talk contribs‎ 42,133 bytes +794‎ →‎Link the components: Explain a bit what the components do.
• curprev 16:3616:36, 14 September 2012‎ BigChimp talk contribs‎ 41,339 bytes +46‎ →‎Project and components: Layout, postgresql example
• curprev 16:1016:10, 14 September 2012‎ BigChimp talk contribs‎ 41,293 bytes +3,421‎ →‎Requirements: Added postgres install notes

30 August 2012

• curprev 15:4615:46, 30 August 2012‎ BigChimp talk contribs‎ 37,872 bytes +162‎ <syntaxhighlight> is better than <source>. See https://www.mediawiki.org/wiki/Extension:SyntaxHighlight_GeSHi#Alternative_Tag
• curprev 15:4015:40, 30 August 2012‎ BigChimp talk contribs‎ 37,710 bytes +1‎ Fixed typo in <syntaxhiglight>. Thanks Markus for drawing attention to this!
• curprev 15:3915:39, 30 August 2012‎ BigChimp talk contribs‎ 37,709 bytes +17‎ Undo revision 61147 by Markusd112: we use syntaxhighlight everywhere instead of source. Better to fix the typo in syntaxhiglight here...
• curprev 12:2112:21, 30 August 2012‎ Markusd112 talk contribs‎ m 37,692 bytes −17‎ Replaced tag syntaxhighlight with source tag in the last listing on the page

2 July 2012

• curprev 15:2715:27, 2 July 2012‎ HowardPC talk contribs‎ m 37,709 bytes +9‎ →‎Introduction
• curprev 15:2015:20, 2 July 2012‎ HowardPC talk contribs‎ m 37,700 bytes −9‎ →‎See also
• curprev 14:0514:05, 2 July 2012‎ BigChimp talk contribs‎ m 37,709 bytes −5‎ →‎SQLite, other databases
• curprev 14:0314:03, 2 July 2012‎ BigChimp talk contribs‎ 37,714 bytes +1‎ →‎No Firebird or employee.fdb installed?: Fixed wrong field type
• curprev 14:0014:00, 2 July 2012‎ BigChimp talk contribs‎ 37,713 bytes +617‎ Use empty filter
• curprev 13:4113:41, 2 July 2012‎ BigChimp talk contribs‎ m 37,096 bytes −1‎ →‎SQLite, other databases
• curprev 13:4013:40, 2 July 2012‎ BigChimp talk contribs‎ 37,097 bytes +649‎ Finished adding sqlite notes in article
• curprev 13:1313:13, 2 July 2012‎ BigChimp talk contribs‎ 36,448 bytes +2,443‎ Moved button lower; sqlite details
• curprev 12:0012:00, 2 July 2012‎ BigChimp talk contribs‎ 34,005 bytes +494‎ Sqlite: creating database

29 March 2012

• curprev 15:1015:10, 29 March 2012‎ BigChimp talk contribs‎ 33,511 bytes +45‎ →‎Firebird on Windows: Link to firebird embedded page

26 March 2012

• curprev 23:1023:10, 26 March 2012‎ Zoran talk contribs‎ 33,466 bytes +22‎ →‎No Firebird or employee.fdb installed?

24 March 2012

• curprev 15:5515:55, 24 March 2012‎ Vincent talk contribs‎ m 33,444 bytes +180‎ Text replace - "delphi>" to "syntaxhighlight>"

23 March 2012

• curprev 23:3023:30, 23 March 2012‎ Rjbosch talk contribs‎ 33,264 bytes +43‎ No edit summary
• curprev 23:2123:21, 23 March 2012‎ Rjbosch talk contribs‎ 33,221 bytes +24‎ No edit summary
• curprev 23:1623:16, 23 March 2012‎ Rjbosch talk contribs‎ 33,197 bytes +24‎ No edit summary

21 March 2012

• curprev 16:2016:20, 21 March 2012‎ BigChimp talk contribs‎ 33,173 bytes −128‎ →‎Error handling: Less detail on reasons for errors - they distract from the discussion.

8 March 2012

• curprev 12:3312:33, 8 March 2012‎ BigChimp talk contribs‎ m 33,301 bytes +93‎ →‎Connecting to the database
• curprev 12:3112:31, 8 March 2012‎ BigChimp talk contribs‎ m 33,208 bytes +12‎ →‎No employee.fdb installed?: Indicate firebird not necessary

9 January 2012

• curprev 16:2016:20, 9 January 2012‎ BigChimp talk contribs‎ m 33,196 bytes −70‎ →‎Deleting data

5 September 2011

• curprev 13:0613:06, 5 September 2011‎ BigChimp talk contribs‎ 33,266 bytes +1,426‎ →‎See also: Embedded database for free ;)
• curprev 12:5512:55, 5 September 2011‎ BigChimp talk contribs‎ m 31,840 bytes +472‎ →‎Summary: updates from previous sections
• curprev 12:5312:53, 5 September 2011‎ BigChimp talk contribs‎ 31,368 bytes +758‎ →‎Inserting new data: Deleting data
• curprev 12:1412:14, 5 September 2011‎ BigChimp talk contribs‎ m 30,610 bytes +2‎ →‎Dynamic database connection: typo
• curprev 12:1012:10, 5 September 2011‎ BigChimp talk contribs‎ 30,608 bytes +962‎ →‎Hiding primary key column: Added insert functionality

4 September 2011

• curprev 15:1715:17, 4 September 2011‎ BigChimp talk contribs‎ 29,646 bytes +425‎ →‎Introduction: Details on German version & Swen's preferences; hint that user can stop after Basic example

3 September 2011

• curprev 14:5414:54, 3 September 2011‎ BigChimp talk contribs‎ 29,221 bytes +190‎ →‎Hiding primary key column: Please help fix this tutorial; added download link https://bitbucket.org/reiniero/fpc_laz_patch_playground/downloads/SQLDBTutorial1_3Sept2011.zip
• curprev 14:4914:49, 3 September 2011‎ BigChimp talk contribs‎ 29,031 bytes +355‎ →‎Introduction: It may seem long, but really, it isn't. Trust me.
• curprev 14:4614:46, 3 September 2011‎ BigChimp talk contribs‎ 28,676 bytes +1,777‎ →‎Editing data using the grid: Hiding first, autonumber column
• curprev 14:3114:31, 3 September 2011‎ BigChimp talk contribs‎ 26,899 bytes +35‎ →‎Dynamic database connection
• curprev 14:1214:12, 3 September 2011‎ BigChimp talk contribs‎ m 26,864 bytes +604‎ →‎Summary: Incorporated code from earlier section
• curprev 14:1114:11, 3 September 2011‎ BigChimp talk contribs‎ m 26,260 bytes +551‎ →‎Filtering data: Incorporated code from previous section
• curprev 14:1014:10, 3 September 2011‎ BigChimp talk contribs‎ m 25,709 bytes −56‎ →‎Dynamic database connection
• curprev 14:0914:09, 3 September 2011‎ BigChimp talk contribs‎ m 25,765 bytes −8‎ →‎Connecting to the database
• curprev 14:0814:08, 3 September 2011‎ BigChimp talk contribs‎ 25,773 bytes +2,856‎ →‎Filtering data: Added dynamic database connection setup

31 August 2011

• curprev 16:3916:39, 31 August 2011‎ BigChimp talk contribs‎ m 22,917 bytes −20‎ →‎See also: Change SQLDBHowto reference from Dutch to English
• curprev 13:4913:49, 31 August 2011‎ BigChimp talk contribs‎ 22,937 bytes −91‎ →‎Choosing what data to show: .Clear is not necessary for sqlquery when using .Text:='bla'
• curprev 11:4111:41, 31 August 2011‎ Billyraybones talk contribs‎ m 23,028 bytes +5‎ typos, some formatting
• curprev 11:1311:13, 31 August 2011‎ BigChimp talk contribs‎ 23,023 bytes +186‎ →‎Editing data using the grid
• curprev 08:2708:27, 31 August 2011‎ BigChimp talk contribs‎ m 22,837 bytes +179‎ →‎Error handling: Other database users
• curprev 08:1308:13, 31 August 2011‎ BigChimp talk contribs‎ m 22,658 bytes +1‎ →‎Requirements

30 August 2011

• curprev 12:0612:06, 30 August 2011‎ BigChimp talk contribs‎ 22,657 bytes +320‎ →‎Project and components: Other databases
• curprev 11:5811:58, 30 August 2011‎ BigChimp talk contribs‎ 22,337 bytes +380‎ →‎Requirements: Allow non-Firebird dbs
• curprev 11:5311:53, 30 August 2011‎ BigChimp talk contribs‎ 21,957 bytes +103‎ →‎Introduction: Grammar, other dbs
• curprev 11:2611:26, 30 August 2011‎ BigChimp talk contribs‎ 21,854 bytes +5,368‎ →‎Enhancement of the basic example: Added editing/data writing
• curprev 11:1411:14, 30 August 2011‎ BigChimp talk contribs‎ 16,486 bytes +8‎ →‎Enhancement of example 1
• curprev 11:1311:13, 30 August 2011‎ BigChimp talk contribs‎ 16,478 bytes +4‎ →‎Example 1

29 August 2011

• curprev 14:1314:13, 29 August 2011‎ BigChimp talk contribs‎ m 16,474 bytes +1‎ →‎Error handling
• curprev 14:0414:04, 29 August 2011‎ BigChimp talk contribs‎ 16,473 bytes +322‎ →‎Filtering data: Minor clarifications
• curprev 13:5613:56, 29 August 2011‎ BigChimp talk contribs‎ m 16,151 bytes +38‎ →‎Connecting to the database
• curprev 12:5212:52, 29 August 2011‎ BigChimp talk contribs‎ m 16,113 bytes +1,202‎ →‎Summary: Moved source code to summary above, more logical - part 2 of 2
• curprev 12:5212:52, 29 August 2011‎ BigChimp talk contribs‎ m 14,911 bytes −1,143‎ →‎Enhancement of example 1: Moved source code to summary above, more logical - part 1
• curprev 12:5012:50, 29 August 2011‎ BigChimp talk contribs‎ m 16,054 bytes +59‎ →‎Database libraries on Windows
• curprev 12:4912:49, 29 August 2011‎ BigChimp talk contribs‎ m 15,995 bytes +82‎ →‎Requirements
• curprev 12:2412:24, 29 August 2011‎ BigChimp talk contribs‎ m 15,913 bytes +59‎ →‎Error handling: Fixed dangling line in rationale. Rationale is still too verbose to my liking, but I won't dismantle the original author's work just because I think it's too wordy ;)
• curprev 12:1512:15, 29 August 2011‎ BigChimp talk contribs‎ m 15,854 bytes −23‎ →‎Enhancement of example 1: Updated program code with Lazarus 0.9.31 generated code
• curprev 12:1112:11, 29 August 2011‎ BigChimp talk contribs‎ m 15,877 bytes +41‎ →‎Connecting to the database
• curprev 12:1012:10, 29 August 2011‎ BigChimp talk contribs‎ m 15,836 bytes +5‎ →‎Choosing what data to show
• curprev 12:0412:04, 29 August 2011‎ BigChimp talk contribs‎ 15,831 bytes +99‎ →‎Connecting to the database
• curprev 11:5811:58, 29 August 2011‎ BigChimp talk contribs‎ 15,732 bytes +154‎ →‎Connecting to the database: Added required hostname - no need to go explaining about embedded mode...
• curprev 11:4411:44, 29 August 2011‎ BigChimp talk contribs‎ m 15,578 bytes 0‎ →‎Requirements
• curprev 11:4311:43, 29 August 2011‎ BigChimp talk contribs‎ m 15,578 bytes +15‎ →‎Requirements
• curprev 11:4311:43, 29 August 2011‎ BigChimp talk contribs‎ m 15,563 bytes +123‎ →‎Requirements
• curprev 11:4111:41, 29 August 2011‎ BigChimp talk contribs‎ 15,440 bytes +916‎ →‎Requirements: Added DLLs
• curprev 11:3211:32, 29 August 2011‎ BigChimp talk contribs‎ m 14,524 bytes +13‎ →‎Connecting to the database
• curprev 11:1611:16, 29 August 2011‎ BigChimp talk contribs‎ m 14,511 bytes +1‎ →‎Chosing what data to show
• curprev 11:1311:13, 29 August 2011‎ BigChimp talk contribs‎ m 14,510 bytes −34‎ →‎Error handling
• curprev 11:1311:13, 29 August 2011‎ BigChimp talk contribs‎ 14,544 bytes +267‎ →‎Enhancement of example 1: Subheadings, enhanced error message
• curprev 10:4510:45, 29 August 2011‎ BigChimp talk contribs‎ 14,277 bytes +127‎ →‎Example 1: Subheaders for additional clarity
• curprev 10:1910:19, 29 August 2011‎ BigChimp talk contribs‎ m 14,150 bytes +2‎ →‎Requirements: newer sqldblaz
• curprev 09:3409:34, 29 August 2011‎ BigChimp talk contribs‎ 14,148 bytes +2,220‎ →‎Requirements: Added Customer table DDL so people stuck with other databases can play along ;)
• curprev 09:0709:07, 29 August 2011‎ BigChimp talk contribs‎ m 11,928 bytes +85‎ →‎Enhancement of example 1
• curprev 09:0209:02, 29 August 2011‎ BigChimp talk contribs‎ 11,843 bytes +330‎ →‎Enhancement of example 1: Grammar,clarity
• curprev 08:4708:47, 29 August 2011‎ BigChimp talk contribs‎ 11,513 bytes +209‎ →‎Example 1: Grammar/wording/layout/clarification
• curprev 08:1508:15, 29 August 2011‎ BigChimp talk contribs‎ m 11,304 bytes +23‎ →‎Requirements
• curprev 07:4607:46, 29 August 2011‎ BigChimp talk contribs‎ m 11,281 bytes +101‎ →‎See also: Added link to Firebird in action, categories

28 August 2011

• curprev 21:1721:17, 28 August 2011‎ Swen talk contribs‎ m 11,180 bytes −9‎ →‎Requirements

13 September 2010

• curprev 12:2412:24, 13 September 2010‎ JimBeam talk contribs‎ m 11,189 bytes −64‎ Translation of a German snippet

26 April 2009

• curprev 21:5721:57, 26 April 2009‎ Swen talk contribs‎ m 11,253 bytes −158‎ →‎Enhancement of example 1
• curprev 21:2121:21, 26 April 2009‎ Swen talk contribs‎ m 11,411 bytes −66‎ →‎Enhancement of example 1

8 April 2009

• curprev 23:2123:21, 8 April 2009‎ Swen talk contribs‎ m 11,477 bytes −179‎ →‎Enhancement of example 1

7 April 2009

• curprev 21:3821:38, 7 April 2009‎ Swen talk contribs‎ m 11,656 bytes −301‎ →‎Example 1
• curprev 20:5820:58, 7 April 2009‎ Swen talk contribs‎ m 11,957 bytes −497‎ No edit summary
• curprev 19:5919:59, 7 April 2009‎ Swen talk contribs‎ 12,454 bytes +12,454‎ New page: {{SQLdb Tutorial}} == Introduction == This tutorial has the intention to show the usage of the SQLdb Package on the basis of practical examples. It is primarily targeted at newbies. ...