Sign in Join
Wiki copytemporary

Working With TSQLQuery: history

RevisionWhenWhoWhat changed
1Kai BurghardtFrom the Free Pascal wiki's dump of 2024-05-26What changed
Edited on wiki.freepascal.org by 13 people, 2008–2022

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.

WhenWhoWhat changed
KirkpatcNew 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...
Kirkpatc
Kirkpatc
Kirkpatc
Michael
MichaelPrimary key fields
MichaelGeneral
MichaelGeneral
MichaelGeneral
MichaelGeneral
SwenGeneral: typo (minor)
Iskraelectrica
Abeomega
Abeomega
AbeomegaTake away unverified assumption (minor)
KirkpatcGeneral
KirkpatcTSQLQuery.SQL: Basic SQL Customization
BigChimpTSQLQuery.SQL: Basic SQL Customization (minor)
BigChimpTSQLQuery.InsertSQL, TSQLQuery.UpdateSQL and TSQLQuery.DeleteSQL: Basic Use of Parameters
BigChimpTSQLQuery.SQL: Basic SQL Customization (minor)
BigChimpTSQLQuery.InsertSQL, TSQLQuery.UpdateSQL and TSQLQuery.DeleteSQL: Basic Use of Parameters: Excamples didn't match description about parameters
BigChimpParameters in TSQLQuery.SQL: Added example; review welcome
BigChimpParameters in TSQLQuery.SQL (minor)
BigChimpParameters in TSQLQuery.SQL: Moved advantages to top, deemphasized difference with insertsql/updatesql/deletesql (minor)
BigChimpParameters in TSQLQuery.SQL (minor)
VincentText replace - "Delphi>" to "syntaxhighlight>" (minor)
BigChimpParameters in TSQLQuery.SQL: Moved examples from Firebird
BigChimpInsert query example (minor)
VincentText replace - "</sql>" to "</syntaxhighlight>" (minor)
VincentText replace - "<SQL>" to "<syntaxhighlight lang="sql">" (minor)
VincentText replace - "</SQL>" to "</syntaxhighlight>" (minor)
BigChimpIndicate what a TSQLQuery is.
BigChimpAdded common errors/troubleshooting section.
BigChimpDataset is read-onlys (minor)
Chronossyntaxhighlight
Chronos
BigChimpGeneral: TSQLQuery can retrieve but also modify.
BigChimpSelect query example: added datatype
MaD70TSQLQuery.InsertSQL, TSQLQuery.UpdateSQL and TSQLQuery.DeleteSQL: Basic Use of Parameters: OLD_ before old parameter values must be all uppercase (see SQLdb unit source).
MaD70TSQLQuery.InsertSQL, TSQLQuery.UpdateSQL and TSQLQuery.DeleteSQL: Basic Use of Parameters: Removed HTML from my editing (changed in MediaWiki syntax). (minor)
BigChimpGeneral: Link to FPC help
BigChimpCustomizing the SQL in TSQLQuery: link to metadata screenshot
BigChimpLink to documentation
BigChimpsqlquery info presented is fpc-specific though it applies to use in laz as well
BigChimpTSQLQuery.InsertSQL, TSQLQuery.UpdateSQL and TSQLQuery.DeleteSQL: Basic Use of Parameters: link to docs
BigChimpadded mini sql browser
BigChimpRunning your own SQL and getting metadata
BigChimpTroubleshooting: out of memory/unidirectional
KapibaraTSQLQuery.InsertSQL, TSQLQuery.UpdateSQL and TSQLQuery.DeleteSQL: Basic Use of Parameters (minor)
KapibaraInsert query example
KapibaraInsert query using C-style printf variables (minor)
KapibaraInsert query using C-style printf variables (minor)
KapibaraInsert query example (minor)
KapibaraInsert query using C-style printf variables (minor)
KapibaraInsert query using C-style printf variables (minor)
KapibaraInsert query with Format function
KapibaraInsert query with Format function (minor)
KapibaraInsert query with Format function (minor)
KapibaraInsert query with Format function (minor)
KapibaraInsert query with Format function (minor)
KapibaraInsert query with Format function (minor)
BigChimpCached Updates (minor)
BigChimpInsert 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.
BigChimpInsert query with Format function
BigChimp
BigChimpInsert query example
BigChimpRunning your own SQL and getting metadata (minor)
BigChimpOut of memory errors (minor)
BigChimpOfficial documentation (minor)
BigChimpOut of memory errors (minor)
BigChimpTroubleshooting: Add performance issues
BigChimpDataset is read-only (minor)
BigChimpOut of memory errors (minor)
BigChimpOut of memory errors (minor)
KapibaraQuery with Format function
KapibaraQuery with Format function (minor)
BigChimpQuery with Format function: why not use a query? Also don't duplicate format explanation - it's not a tutorial
KapibaraQuery with Format function
Arent
ArentCommonly used controls
Arent
ArentCustomizing the SQL in TSQLQuery
ArentCustomizing the SQL in TSQLQuery
TrevFixed syntax highlighting; deleted category included in page template (minor)
Kai Burghardtremove implausible redlink and that have changed (minor)

Back to the page