From the official wiki's backup of 26 May 2024: who edited this page there, and when. Edits made there after that date were not recorded, and the earlier versions are not shown here; the main page says why.
When Who What changed 4-7-2009 Swen 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. ... 4-7-2009 Swen (minor) 4-7-2009 Swen Example 1 (minor) 4-8-2009 Swen Enhancement of example 1 (minor) 4-26-2009 Swen Enhancement of example 1 (minor) 4-26-2009 Swen Enhancement of example 1 (minor) 9-13-2010 JimBeam Translation of a German snippet (minor) 8-28-2011 Swen Requirements (minor) 8-29-2011 BigChimp See also: Added link to Firebird in action, categories (minor) 8-29-2011 BigChimp Requirements (minor) 8-29-2011 BigChimp Example 1: Grammar/wording/layout/clarification 8-29-2011 BigChimp Enhancement of example 1: Grammar,clarity 8-29-2011 BigChimp Enhancement of example 1 (minor) 8-29-2011 BigChimp Requirements: Added Customer table DDL so people stuck with other databases can play along ;) 8-29-2011 BigChimp Requirements: newer sqldblaz (minor) 8-29-2011 BigChimp Example 1: Subheaders for additional clarity 8-29-2011 BigChimp Enhancement of example 1: Subheadings, enhanced error message 8-29-2011 BigChimp Error handling (minor) 8-29-2011 BigChimp Chosing what data to show (minor) 8-29-2011 BigChimp Connecting to the database (minor) 8-29-2011 BigChimp Requirements: Added DLLs 8-29-2011 BigChimp Requirements (minor) 8-29-2011 BigChimp Requirements (minor) 8-29-2011 BigChimp Requirements (minor) 8-29-2011 BigChimp Connecting to the database: Added required hostname - no need to go explaining about embedded mode... 8-29-2011 BigChimp Connecting to the database 8-29-2011 BigChimp Choosing what data to show (minor) 8-29-2011 BigChimp Connecting to the database (minor) 8-29-2011 BigChimp Enhancement of example 1: Updated program code with Lazarus 0.9.31 generated code (minor) 8-29-2011 BigChimp 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 ;) (minor) 8-29-2011 BigChimp Requirements (minor) 8-29-2011 BigChimp Database libraries on Windows (minor) 8-29-2011 BigChimp Enhancement of example 1: Moved source code to summary above, more logical - part 1 (minor) 8-29-2011 BigChimp Summary: Moved source code to summary above, more logical - part 2 of 2 (minor) 8-29-2011 BigChimp Connecting to the database (minor) 8-29-2011 BigChimp Filtering data: Minor clarifications 8-29-2011 BigChimp Error handling (minor) 8-30-2011 BigChimp Example 1 8-30-2011 BigChimp Enhancement of example 1 8-30-2011 BigChimp Enhancement of the basic example: Added editing/data writing 8-30-2011 BigChimp Introduction: Grammar, other dbs 8-30-2011 BigChimp Requirements: Allow non-Firebird dbs 8-30-2011 BigChimp Project and components: Other databases 8-31-2011 BigChimp Requirements (minor) 8-31-2011 BigChimp Error handling: Other database users (minor) 8-31-2011 BigChimp Editing data using the grid 8-31-2011 Billyraybones typos, some formatting (minor) 8-31-2011 BigChimp Choosing what data to show: .Clear is not necessary for sqlquery when using .Text:='bla' 8-31-2011 BigChimp See also: Change SQLDBHowto reference from Dutch to English (minor) 9-3-2011 BigChimp Filtering data: Added dynamic database connection setup 9-3-2011 BigChimp Connecting to the database (minor) 9-3-2011 BigChimp Dynamic database connection (minor) 9-3-2011 BigChimp Filtering data: Incorporated code from previous section (minor) 9-3-2011 BigChimp Summary: Incorporated code from earlier section (minor) 9-3-2011 BigChimp Dynamic database connection 9-3-2011 BigChimp Editing data using the grid: Hiding first, autonumber column 9-3-2011 BigChimp Introduction: It may seem long, but really, it isn't. Trust me. 9-3-2011 BigChimp Hiding primary key column: Please help fix this tutorial; added download link https://bitbucket.org/reiniero/fpc_laz_patch_playground/downloads/SQLDBTutorial1_3Sept2011.zip 9-4-2011 BigChimp Introduction: Details on German version & Swen's preferences; hint that user can stop after Basic example 9-5-2011 BigChimp Hiding primary key column: Added insert functionality 9-5-2011 BigChimp Dynamic database connection: typo (minor) 9-5-2011 BigChimp Inserting new data: Deleting data 9-5-2011 BigChimp Summary: updates from previous sections (minor) 9-5-2011 BigChimp See also: Embedded database for free ;) 1-9-2012 BigChimp Deleting data (minor) 3-8-2012 BigChimp No employee.fdb installed?: Indicate firebird not necessary (minor) 3-8-2012 BigChimp Connecting to the database (minor) 3-21-2012 BigChimp Error handling: Less detail on reasons for errors - they distract from the discussion. 3-23-2012 Rjbosch 3-23-2012 Rjbosch 3-23-2012 Rjbosch 3-24-2012 Vincent Text replace - "delphi>" to "syntaxhighlight>" (minor) 3-26-2012 Zoran No Firebird or employee.fdb installed? 3-29-2012 BigChimp Firebird on Windows: Link to firebird embedded page 7-2-2012 BigChimp Sqlite: creating database 7-2-2012 BigChimp Moved button lower; sqlite details 7-2-2012 BigChimp Finished adding sqlite notes in article 7-2-2012 BigChimp SQLite, other databases (minor) 7-2-2012 BigChimp Use empty filter 7-2-2012 BigChimp No Firebird or employee.fdb installed?: Fixed wrong field type 7-2-2012 BigChimp SQLite, other databases (minor) 7-2-2012 HowardPC See also (minor) 7-2-2012 HowardPC Introduction (minor) 8-30-2012 Markusd112 Replaced tag syntaxhighlight with source tag in the last listing on the page (minor) 8-30-2012 BigChimp Undo revision 61147 by Markusd112: we use syntaxhighlight everywhere instead of source. Better to fix the typo in syntaxhiglight here... 8-30-2012 BigChimp Fixed typo in <syntaxhiglight>. Thanks Markus for drawing attention to this! 8-30-2012 BigChimp <syntaxhighlight> is better than <source>. See https://www.mediawiki.org/wiki/Extension:SyntaxHighlight_GeSHi#Alternative_Tag 9-14-2012 BigChimp Requirements: Added postgres install notes 9-14-2012 BigChimp Project and components: Layout, postgresql example 9-14-2012 BigChimp Link the components: Explain a bit what the components do. 9-14-2012 BigChimp Connecting to the database: postgresql notes 9-14-2012 BigChimp = PostgreSQL (minor) 9-14-2012 BigChimp SQLite, other database 9-14-2012 BigChimp See also 9-14-2012 BigChimp PostgreSQL 9-14-2012 BigChimp No Firebird or employee.fdb installed?: Stay within VARCHAR(25) (minor) 9-14-2012 BigChimp No Firebird or employee.fdb installed?: Change cust no to match postgresql serial datatype (minor) 9-14-2012 BigChimp PostgreSQL: Added serial cust_no instead of regular insert. This should let inserts work. 9-15-2012 BigChimp Split up sql db tutorial for brevity/apparent complexity 9-15-2012 BigChimp (minor) 9-15-2012 BigChimp remove superfluous SQLQuery1.clear 9-25-2012 Chronos fixed link 11-7-2012 Cuniculophile moved SQLdb Tutorial1 to SQLdb Tutorial1 (Français): Je n'ai pas trouvé comment signifier qu'il s'agissait d'une traduction (minor) 11-7-2012 Cuniculophile moved SQLdb Tutorial1 (Français) to SQLdb Tutorial1 over redirect (minor) 11-14-2012 BigChimp Links to tutorial3, cosmetic copy/paste error fixed (minor) 11-15-2012 BigChimp Added salary column used in sqldb tutorial3 11-15-2012 BigChimp Undo revision 63973 by BigChimp (talk) 11-15-2012 BigChimp Added employee example ready for sqldbtutorial3 11-15-2012 BigChimp No Firebird or employee.fdb installed? (minor) 11-18-2012 BigChimp Installation on Linux: update with -dev library 11-18-2012 BigChimp Firebird database libraries on other systems (minor) 11-18-2012 BigChimp Indicate postgresql and sqlite already catered for; clarify windows lib instructions 11-18-2012 BigChimp Link the components (minor) 11-18-2012 BigChimp Connecting to the database 11-18-2012 BigChimp Choosing what data to show: button caption 12-4-2012 Tangentstorm Firebird database libraries on Windows (minor) 12-21-2012 BigChimp Database dlls should be in Lazarus directory, not project directory 1-13-2013 BigChimp SQLite (minor) 1-13-2013 BigChimp SQLite (minor) 1-13-2013 BigChimp PostgreSQL: layout, clarificaton on insert statements 5-9-2013 Bertman Changed customer and employee data statements to make the SQL-statements work when copied (minor) 10-17-2013 Bartlebee corrected typo. Added small comment for sqlite (minor) 10-17-2013 Bartlebee SQLite: A regular name does not work. Needs the entire path. 11-22-2013 BigChimp moved install instructions to tutorial0 11-22-2013 BigChimp See also (minor) 11-22-2013 BigChimp (minor) 12-12-2013 Bartlebee Undo revision 73555 by Bartlebee (talk) I realize I was incorrect 3-11-2014 BigChimp Project and components: image 5-10-2015 Socke Connecting to the database: fixed broken link (minor) 7-15-2015 FTurtle 10-17-2015 Kapibara Choosing what data to show 8-15-2016 Arent 3-2-2017 Arent Basic example 3-2-2017 Arent Project and components 3-2-2017 Arent Project and components 3-2-2017 Arent Project and components 2-26-2020 Trev Fixed syntax highlighting; deleted category included in page template (minor) 11-1-2022 Kj14 added note to SQLite section about (MEMO) text fields
