History of Working With TSQLQuery
- diff 2022-08-10 13:44 UTC Kai Burghardt (contribs) m 18886 bytes (-4) remove implausible redlink [[and that have changed]]
- diff 2020-03-04 10:37 UTC Trev (contribs) m 18890 bytes (-47) Fixed syntax highlighting; deleted category included in page template
- diff 2017-02-24 19:29 UTC Arent (contribs) 18937 bytes (-38) /* Customizing the SQL in TSQLQuery */
- diff 2016-09-05 21:57 UTC Arent (contribs) 18975 bytes (+22) /* Customizing the SQL in TSQLQuery */
- diff 2016-08-15 10:12 UTC Arent (contribs) 18953 bytes (+26)
- diff 2016-08-04 11:31 UTC Arent (contribs) 18927 bytes (+24) /* Commonly used controls */
- diff 2016-08-04 11:29 UTC Arent (contribs) 18903 bytes (-23)
- diff 2014-11-05 04:10 UTC Kapibara (contribs) 18926 bytes (-450) /* Query with Format function */
- diff 2014-10-24 08:16 UTC BigChimp (contribs) 19376 bytes (+55) /* Query with Format function */ why not use a query? Also don't duplicate format explanation - it's not a tutorial
- diff 2014-10-23 23:59 UTC Kapibara (contribs) m 19321 bytes (-1) /* Query with Format function */
- diff 2014-10-23 23:58 UTC Kapibara (contribs) 19322 bytes (+478) /* Query with Format function */
- diff 2014-10-18 03:02 UTC BigChimp (contribs) m 18844 bytes (-7) /* Out of memory errors */
- diff 2014-10-18 03:01 UTC BigChimp (contribs) m 18851 bytes (+78) /* Out of memory errors */
- diff 2014-09-15 12:03 UTC BigChimp (contribs) m 18773 bytes (-1) /* Dataset is read-only */
- diff 2014-09-15 12:03 UTC BigChimp (contribs) 18774 bytes (+277) /* Troubleshooting */ Add performance issues
- diff 2014-09-15 12:01 UTC BigChimp (contribs) m 18497 bytes (+36) /* Out of memory errors */
- diff 2014-05-27 11:55 UTC BigChimp (contribs) m 18461 bytes (-14) /* Official documentation */
- diff 2014-05-25 19:46 UTC BigChimp (contribs) m 18475 bytes (+8) /* Out of memory errors */
- diff 2014-05-25 19:45 UTC BigChimp (contribs) m 18467 bytes (-4) /* Running your own SQL and getting metadata */
- diff 2014-05-25 19:44 UTC BigChimp (contribs) 18471 bytes (-121) /* Insert query example */
- diff 2014-05-24 16:43 UTC BigChimp (contribs) 18592 bytes (+127)
- diff 2014-02-21 11:20 UTC BigChimp (contribs) 18465 bytes (+110) /* Insert query with Format function */
- diff 2014-02-21 11:19 UTC BigChimp (contribs) 18355 bytes (+2) /* Insert query with Format function */ This is actually not a parametrized query... it's not prepared once on the server, but run from the client every time.
- diff 2014-02-21 11:00 UTC BigChimp (contribs) m 18353 bytes (0) /* Cached Updates */
- diff 2014-02-19 06:23 UTC Kapibara (contribs) m 18353 bytes (-4) /* Insert query with Format function */
- diff 2014-02-19 06:23 UTC Kapibara (contribs) m 18357 bytes (+78) /* Insert query with Format function */
- diff 2014-02-19 06:16 UTC Kapibara (contribs) m 18279 bytes (-10) /* Insert query with Format function */
- diff 2014-02-19 00:04 UTC Kapibara (contribs) m 18289 bytes (+2) /* Insert query with Format function */
- diff 2014-02-19 00:04 UTC Kapibara (contribs) m 18287 bytes (+93) /* Insert query with Format function */
- diff 2014-02-18 23:38 UTC Kapibara (contribs) 18194 bytes (+129) /* Insert query with Format function */
- diff 2014-02-18 23:33 UTC Kapibara (contribs) m 18065 bytes (-10) /* Insert query using C-style printf variables */
- diff 2014-02-18 23:29 UTC Kapibara (contribs) m 18075 bytes (0) /* Insert query using C-style printf variables */
- diff 2014-02-18 23:28 UTC Kapibara (contribs) m 18075 bytes (+121) /* Insert query example */
- diff 2014-02-18 23:28 UTC Kapibara (contribs) m 17954 bytes (-75) /* Insert query using C-style printf variables */
- diff 2014-02-18 23:27 UTC Kapibara (contribs) m 18029 bytes (-41) /* Insert query using C-style printf variables */
- diff 2014-02-18 23:21 UTC Kapibara (contribs) 18070 bytes (+578) /* Insert query example */
- diff 2014-01-21 19:33 UTC Kapibara (contribs) m 17492 bytes (+1) /* TSQLQuery.InsertSQL, TSQLQuery.UpdateSQL and TSQLQuery.DeleteSQL: Basic Use of Parameters */
- diff 2014-01-07 13:07 UTC BigChimp (contribs) 17491 bytes (+520) /* Troubleshooting */ out of memory/unidirectional
- diff 2013-11-28 15:43 UTC BigChimp (contribs) 16971 bytes (+67) /* Running your own SQL and getting metadata */
- diff 2013-11-28 15:39 UTC BigChimp (contribs) 16904 bytes (+704) added mini sql browser
- diff 2013-11-18 11:39 UTC BigChimp (contribs) 16200 bytes (+339) /* TSQLQuery.InsertSQL, TSQLQuery.UpdateSQL and TSQLQuery.DeleteSQL: Basic Use of Parameters */ link to docs
- diff 2013-02-02 09:45 UTC BigChimp (contribs) 15861 bytes (+10) sqlquery info presented is fpc-specific though it applies to use in laz as well
- diff 2013-02-02 09:27 UTC BigChimp (contribs) 15851 bytes (+98) Link to documentation
- diff 2012-12-03 14:18 UTC BigChimp (contribs) 15753 bytes (+120) /* Customizing the SQL in TSQLQuery */ link to metadata screenshot
- diff 2012-09-29 10:54 UTC BigChimp (contribs) 15633 bytes (+403) /* General */ Link to FPC help
- diff 2012-09-14 14:51 UTC MaD70 (contribs) m 15230 bytes (0) /* TSQLQuery.InsertSQL, TSQLQuery.UpdateSQL and TSQLQuery.DeleteSQL: Basic Use of Parameters */ Removed HTML from my editing (changed in MediaWiki syntax).
- diff 2012-09-12 18:08 UTC MaD70 (contribs) 15230 bytes (+104) /* TSQLQuery.InsertSQL, TSQLQuery.UpdateSQL and TSQLQuery.DeleteSQL: Basic Use of Parameters */ OLD_ before old parameter values must be all uppercase (see SQLdb unit source).
- diff 2012-06-20 08:24 UTC BigChimp (contribs) 15126 bytes (+196) /* Select query example */ added datatype
- diff 2012-05-19 06:41 UTC BigChimp (contribs) 14930 bytes (+478) /* General */ TSQLQuery can retrieve but also modify.
- diff 2012-05-11 12:49 UTC Chronos (contribs) 14452 bytes (-25)
- diff 2012-05-11 12:48 UTC Chronos (contribs) 14477 bytes (0) syntaxhighlight
- diff 2012-05-10 15:24 UTC BigChimp (contribs) m 14477 bytes (0) /* Dataset is read-onlys */
- diff 2012-05-10 15:21 UTC BigChimp (contribs) 14477 bytes (+687) Added common errors/troubleshooting section.
- diff 2012-04-04 06:38 UTC BigChimp (contribs) 13790 bytes (+208) Indicate what a TSQLQuery is.
- diff 2012-03-27 05:54 UTC Vincent (contribs) m 13582 bytes (-98) Text replace - "</SQL>" to "</syntaxhighlight>"
- diff 2012-03-27 05:54 UTC Vincent (contribs) m 13680 bytes (+43) Text replace - "<SQL>" to "<syntaxhighlight lang="sql">"
- diff 2012-03-27 05:49 UTC Vincent (contribs) m 13637 bytes (+36) Text replace - "</sql>" to "</syntaxhighlight>"
- diff 2012-03-25 09:12 UTC BigChimp (contribs) m 13601 bytes (-38) /* Insert query example */
- diff 2012-03-25 09:10 UTC BigChimp (contribs) 13639 bytes (+813) /* Parameters in TSQLQuery.SQL */ Moved examples from Firebird
- diff 2012-03-24 22:50 UTC Vincent (contribs) m 12826 bytes (-7) Text replace - "Delphi>" to "syntaxhighlight>"
- diff 2012-03-18 11:42 UTC BigChimp (contribs) m 12833 bytes (-2) /* Parameters in TSQLQuery.SQL */
- diff 2012-03-18 11:41 UTC BigChimp (contribs) m 12835 bytes (+44) /* Parameters in TSQLQuery.SQL */ Moved advantages to top, deemphasized difference with insertsql/updatesql/deletesql
- diff 2012-01-21 09:46 UTC BigChimp (contribs) m 12791 bytes (-71) /* Parameters in TSQLQuery.SQL */
- diff 2012-01-21 09:32 UTC BigChimp (contribs) 12862 bytes (+893) /* Parameters in TSQLQuery.SQL */ Added example; review welcome
- diff 2012-01-21 09:22 UTC BigChimp (contribs) 11969 bytes (+200) /* TSQLQuery.InsertSQL, TSQLQuery.UpdateSQL and TSQLQuery.DeleteSQL: Basic Use of Parameters */ Excamples didn't match description about parameters
- diff 2012-01-21 09:15 UTC BigChimp (contribs) m 11769 bytes (+1) /* TSQLQuery.SQL: Basic SQL Customization */
- diff 2012-01-21 09:14 UTC BigChimp (contribs) 11768 bytes (+1338) /* TSQLQuery.InsertSQL, TSQLQuery.UpdateSQL and TSQLQuery.DeleteSQL: Basic Use of Parameters */
- diff 2012-01-21 08:47 UTC BigChimp (contribs) m 10430 bytes (+34) /* TSQLQuery.SQL: Basic SQL Customization */
- diff 2011-07-08 07:39 UTC Kirkpatc (contribs) 10396 bytes (0) /* TSQLQuery.SQL: Basic SQL Customization */
- diff 2011-07-08 07:38 UTC Kirkpatc (contribs) 10396 bytes (-3) /* General */
- diff 2010-05-18 15:54 UTC Abeomega (contribs) m 10399 bytes (-79) Take away unverified assumption
- diff 2010-05-18 13:33 UTC Abeomega (contribs) 10478 bytes (+2240)
- diff 2010-05-17 19:11 UTC Abeomega (contribs) 8238 bytes (+3036)
- diff 2008-07-07 09:22 UTC Iskraelectrica (contribs) 5202 bytes (+31)
- diff 2008-06-20 14:25 UTC Swen (contribs) m 5171 bytes (0) /* General */ typo
- diff 2008-06-20 13:30 UTC Michael (contribs) 5171 bytes (+655) /* General */
- diff 2008-06-20 13:24 UTC Michael (contribs) 4516 bytes (+18) /* General */
- diff 2008-06-20 13:23 UTC Michael (contribs) 4498 bytes (+87) /* General */
- diff 2008-06-20 13:20 UTC Michael (contribs) 4411 bytes (+105) /* General */
- diff 2008-06-20 13:16 UTC Michael (contribs) 4306 bytes (+1489) /* Primary key fields */
- diff 2008-06-20 12:56 UTC Michael (contribs) 2817 bytes (+1261)
- diff 2008-02-03 17:56 UTC Kirkpatc (contribs) 1556 bytes (-3)
- diff 2008-02-01 17:30 UTC Kirkpatc (contribs) 1559 bytes (+938)
- diff 2008-01-31 23:39 UTC Kirkpatc (contribs) 621 bytes (+1)
- diff 2008-01-30 17:12 UTC Kirkpatc (contribs) 620 bytes New page: If you ned to be able to DELETE or otherwise modify records, your database table should contain one PRIMARY KEY column that has the property AUTO_INCREMENT. This enables the DELETE method...