SQLdb Tutorial1: revisions

RevisionChangesTimeUserSizeComment
59801diffArent (contribs)12951/* Basic example */
59800diffArent (contribs)12954
59799diffKapibara (contribs)12928/* Choosing what data to show */
59798diffFTurtle (contribs)12789
59797diffSocke (contribs)12788m /* Connecting to the database */ fixed broken link
59796diffBigChimp (contribs)12788/* Project and components */ image
59795diffBartlebee (contribs)12724Undo revision 73555 by [[Special:Contributions/Bartlebee|Bartlebee]] ([[User talk:Bartlebee|talk]]) I realize I was incorrect
59794diffBigChimp (contribs)12737m
59793diffBigChimp (contribs)12643m /* See also */
59792diffBigChimp (contribs)12541moved install instructions to tutorial0
59791diffBartlebee (contribs)22822/* SQLite */ A regular name does not work. Needs the entire path.
59790diffBartlebee (contribs)22809m corrected typo. Added small comment for sqlite
59789diffBertman (contribs)22732m Changed customer and employee data statements to make the SQL-statements work when copied
59788diffBigChimp (contribs)22739/* PostgreSQL */ layout, clarificaton on insert statements
59787diffBigChimp (contribs)22650m /* SQLite */
59786diffBigChimp (contribs)22638m /* SQLite */
59785diffBigChimp (contribs)22637Database dlls should be in Lazarus directory, not project directory
59784diffTangentstorm (contribs)22512m /* Firebird database libraries on Windows */
59783diffBigChimp (contribs)22470/* Choosing what data to show */ button caption
59782diffBigChimp (contribs)22409/* Connecting to the database */
59781diffBigChimp (contribs)22156m /* Link the components */
59780diffBigChimp (contribs)22153Indicate postgresql and sqlite already catered for; clarify windows lib instructions
59779diffBigChimp (contribs)22076m /* Firebird database libraries on other systems */
59778diffBigChimp (contribs)22134Installation on Linux: update with -dev library
59777diffBigChimp (contribs)21987m /* No Firebird or employee.fdb installed? */
59776diffBigChimp (contribs)21991Added employee example ready for sqldbtutorial3
59775diffBigChimp (contribs)20612Undo revision 63973 by [[Special:Contributions/BigChimp|BigChimp]] ([[User talk:BigChimp|talk]])
59774diffBigChimp (contribs)20741Added salary column used in sqldb tutorial3
59773diffBigChimp (contribs)20612m Links to tutorial3, cosmetic copy/paste error fixed
59772diffCuniculophile (contribs)20413m moved [[SQLdb Tutorial1 (Français)]] to [[SQLdb Tutorial1]] over redirect
59771diffCuniculophile (contribs)20413m moved [[SQLdb Tutorial1]] to [[SQLdb Tutorial1 (Français)]]: Je n'ai pas trouvé comment signifier qu'il s'agissait d'une traduction
59770diffChronos (contribs)20413fixed link
59769diffBigChimp (contribs)20413remove superfluous SQLQuery1.clear
59768diffBigChimp (contribs)20436m
59767diffBigChimp (contribs)20437Split up sql db tutorial for brevity/apparent complexity
59766diffBigChimp (contribs)41412/* PostgreSQL */ Added serial cust_no instead of regular insert. This should let inserts work.
59765diffBigChimp (contribs)41297m /* No Firebird or employee.fdb installed? */ Change cust no to match postgresql serial datatype
59764diffBigChimp (contribs)41336m /* No Firebird or employee.fdb installed? */ Stay within VARCHAR(25)
59763diffBigChimp (contribs)41345/* PostgreSQL */
59762diffBigChimp (contribs)41193/* See also */
59761diffBigChimp (contribs)41131/* SQLite, other database */
59760diffBigChimp (contribs)41050m /* = PostgreSQL */
59759diffBigChimp (contribs)41051/* Connecting to the database */ postgresql notes
59758diffBigChimp (contribs)40762/* Link the components */ Explain a bit what the components do.
59757diffBigChimp (contribs)39978/* Project and components */ Layout, postgresql example
59756diffBigChimp (contribs)39934/* Requirements */ Added postgres install notes
59755diffBigChimp (contribs)36756<syntaxhighlight> is better than <source>. See https://www.mediawiki.org/wiki/Extension:SyntaxHighlight_GeSHi#Alternative_Tag
59754diffBigChimp (contribs)36756Fixed typo in <syntaxhiglight>. Thanks Markus for drawing attention to this!
59753diffBigChimp (contribs)36740Undo revision 61147 by [[Special:Contributions/Markusd112|Markusd112]]: we use syntaxhighlight everywhere instead of source. Better to fix the typo in syntaxhiglight here...
59752diffMarkusd112 (contribs)36756m Replaced tag syntaxhighlight with source tag in the last listing on the page
59751diffHowardPC (contribs)36740m /* Introduction */
59750diffHowardPC (contribs)36731m /* See also */
59749diffBigChimp (contribs)36740m /* SQLite, other databases */
59748diffBigChimp (contribs)36745/* No Firebird or employee.fdb installed? */ Fixed wrong field type
59747diffBigChimp (contribs)36744Use empty filter
59746diffBigChimp (contribs)36179m /* SQLite, other databases */
59745diffBigChimp (contribs)36181Finished adding sqlite notes in article
59744diffBigChimp (contribs)35605Moved button lower; sqlite details
59743diffBigChimp (contribs)33295Sqlite: creating database
59742diffBigChimp (contribs)32875/* Firebird on Windows */ Link to firebird embedded page
59741diffZoran (contribs)32830/* No Firebird or employee.fdb installed? */
59740diffVincent (contribs)32836m Text replace - "delphi>" to "syntaxhighlight>"
59739diffRjbosch (contribs)32924
59738diffRjbosch (contribs)32923
59737diffRjbosch (contribs)32991
59736diffBigChimp (contribs)32995/* Error handling */ Less detail on reasons for errors - they distract from the discussion.
59735diffBigChimp (contribs)33124m /* Connecting to the database */
59734diffBigChimp (contribs)33031m /* No employee.fdb installed? */ Indicate firebird not necessary
59733diffBigChimp (contribs)33019m /* Deleting data */
59732diffBigChimp (contribs)33089/* See also */ Embedded database for free ;)
59731diffBigChimp (contribs)31713m /* Summary */ updates from previous sections
59730diffBigChimp (contribs)31255/* Inserting new data */ Deleting data
59729diffBigChimp (contribs)30508m /* Dynamic database connection */ typo
59728diffBigChimp (contribs)30506/* Hiding primary key column */ Added insert functionality
59727diffBigChimp (contribs)29551/* Introduction */ Details on German version & Swen's preferences; hint that user can stop after Basic example
59726diffBigChimp (contribs)29126/* Hiding primary key column */ Please help fix this tutorial; added download link https://bitbucket.org/reiniero/fpc_laz_patch_playground/downloads/SQLDBTutorial1_3Sept2011.zip
59725diffBigChimp (contribs)28936/* Introduction */ It may seem long, but really, it isn't. Trust me.
59724diffBigChimp (contribs)28581/* Editing data using the grid */ Hiding first, autonumber column
59723diffBigChimp (contribs)26811/* Dynamic database connection */
59722diffBigChimp (contribs)26776m /* Summary */ Incorporated code from earlier section
59721diffBigChimp (contribs)26187m /* Filtering data */ Incorporated code from previous section
59720diffBigChimp (contribs)25650m /* Dynamic database connection */
59719diffBigChimp (contribs)25705m /* Connecting to the database */
59718diffBigChimp (contribs)25713/* Filtering data */ Added dynamic database connection setup
59717diffBigChimp (contribs)22869m /* See also */ Change SQLDBHowto reference from Dutch to English
59716diffBigChimp (contribs)22889/* Choosing what data to show */ .Clear is not necessary for sqlquery when using .Text:='bla'
59715diffBillyraybones (contribs)22982m typos, some formatting
59714diffBigChimp (contribs)22988/* Editing data using the grid */
59713diffBigChimp (contribs)22806m /* Error handling */ Other database users
59712diffBigChimp (contribs)22627m /* Requirements */
59711diffBigChimp (contribs)22626/* Project and components */ Other databases
59710diffBigChimp (contribs)22312/* Requirements */ Allow non-Firebird dbs
59709diffBigChimp (contribs)21934/* Introduction */ Grammar, other dbs
59708diffBigChimp (contribs)21831/* Enhancement of the basic example */ Added editing/data writing
59707diffBigChimp (contribs)16414/* Enhancement of example 1 */
59706diffBigChimp (contribs)16406/* Example 1 */
59705diffBigChimp (contribs)16402m /* Error handling */
59704diffBigChimp (contribs)16401/* Filtering data */ Minor clarifications
59703diffBigChimp (contribs)16069m /* Connecting to the database */
59702diffBigChimp (contribs)16031m /* Summary */ Moved source code to summary above, more logical - part 2 of 2