Working With TSQLQuery: Revision history

19 February 2014

• curprev 01:2101:21, 19 February 2014‎ Kapibara talk contribs‎ 18,756 bytes +604‎ →‎Insert query example

21 January 2014

• curprev 21:3321:33, 21 January 2014‎ Kapibara talk contribs‎ m 18,152 bytes +1‎ →‎TSQLQuery.InsertSQL, TSQLQuery.UpdateSQL and TSQLQuery.DeleteSQL: Basic Use of Parameters

7 January 2014

• curprev 15:0715:07, 7 January 2014‎ BigChimp talk contribs‎ 18,151 bytes +545‎ →‎Troubleshooting: out of memory/unidirectional

28 November 2013

• curprev 17:4317:43, 28 November 2013‎ BigChimp talk contribs‎ 17,606 bytes +67‎ →‎Running your own SQL and getting metadata
• curprev 17:3917:39, 28 November 2013‎ BigChimp talk contribs‎ 17,539 bytes +734‎ added mini sql browser

18 November 2013

• curprev 13:3913:39, 18 November 2013‎ BigChimp talk contribs‎ 16,805 bytes +335‎ →‎TSQLQuery.InsertSQL, TSQLQuery.UpdateSQL and TSQLQuery.DeleteSQL: Basic Use of Parameters: link to docs

2 February 2013

• curprev 11:4511:45, 2 February 2013‎ BigChimp talk contribs‎ 16,470 bytes +17‎ sqlquery info presented is fpc-specific though it applies to use in laz as well
• curprev 11:2711:27, 2 February 2013‎ BigChimp talk contribs‎ 16,453 bytes +97‎ Link to documentation

3 December 2012

• curprev 16:1816:18, 3 December 2012‎ BigChimp talk contribs‎ 16,356 bytes +120‎ →‎Customizing the SQL in TSQLQuery: link to metadata screenshot

29 September 2012

• curprev 12:5412:54, 29 September 2012‎ BigChimp talk contribs‎ 16,236 bytes +427‎ →‎General: Link to FPC help

14 September 2012

• curprev 16:5116:51, 14 September 2012‎ MaD70 talk contribs‎ m 15,809 bytes −35‎ →‎TSQLQuery.InsertSQL, TSQLQuery.UpdateSQL and TSQLQuery.DeleteSQL: Basic Use of Parameters: Removed HTML from my editing (changed in MediaWiki syntax).

12 September 2012

• curprev 20:0820:08, 12 September 2012‎ MaD70 talk contribs‎ 15,844 bytes +148‎ →‎TSQLQuery.InsertSQL, TSQLQuery.UpdateSQL and TSQLQuery.DeleteSQL: Basic Use of Parameters: OLD_ before old parameter values must be all uppercase (see SQLdb unit source).

20 June 2012

• curprev 10:2410:24, 20 June 2012‎ BigChimp talk contribs‎ 15,696 bytes +196‎ →‎Select query example: added datatype

19 May 2012

• curprev 08:4108:41, 19 May 2012‎ BigChimp talk contribs‎ 15,500 bytes +478‎ →‎General: TSQLQuery can retrieve but also modify.

11 May 2012

• curprev 14:4914:49, 11 May 2012‎ Chronos talk contribs‎ 15,022 bytes +12‎ No edit summary
• curprev 14:4814:48, 11 May 2012‎ Chronos talk contribs‎ 15,010 bytes +40‎ syntaxhighlight

10 May 2012

• curprev 17:2417:24, 10 May 2012‎ BigChimp talk contribs‎ m 14,970 bytes 0‎ →‎Dataset is read-onlys
• curprev 17:2117:21, 10 May 2012‎ BigChimp talk contribs‎ 14,970 bytes +698‎ Added common errors/troubleshooting section.

4 April 2012

• curprev 08:3808:38, 4 April 2012‎ BigChimp talk contribs‎ 14,272 bytes +214‎ Indicate what a TSQLQuery is.

27 March 2012

• curprev 07:5407:54, 27 March 2012‎ Vincent talk contribs‎ m 14,058 bytes +24‎ Text replace - "</SQL>" to "</syntaxhighlight>"
• curprev 07:5407:54, 27 March 2012‎ Vincent talk contribs‎ m 14,034 bytes +115‎ Text replace - "<SQL>" to "<syntaxhighlight lang="sql">"
• curprev 07:4907:49, 27 March 2012‎ Vincent talk contribs‎ m 13,919 bytes +36‎ Text replace - "</sql>" to "</syntaxhighlight>"

25 March 2012

• curprev 11:1211:12, 25 March 2012‎ BigChimp talk contribs‎ m 13,883 bytes −6‎ →‎Insert query example
• curprev 11:1011:10, 25 March 2012‎ BigChimp talk contribs‎ 13,889 bytes +829‎ →‎Parameters in TSQLQuery.SQL: Moved examples from Firebird
• curprev 00:5000:50, 25 March 2012‎ Vincent talk contribs‎ m 13,060 bytes +18‎ Text replace - "Delphi>" to "syntaxhighlight>"

18 March 2012

• curprev 13:4213:42, 18 March 2012‎ BigChimp talk contribs‎ m 13,042 bytes 0‎ →‎Parameters in TSQLQuery.SQL
• curprev 13:4113:41, 18 March 2012‎ BigChimp talk contribs‎ m 13,042 bytes +47‎ →‎Parameters in TSQLQuery.SQL: Moved advantages to top, deemphasized difference with insertsql/updatesql/deletesql

21 January 2012

• curprev 11:4611:46, 21 January 2012‎ BigChimp talk contribs‎ m 12,995 bytes −71‎ →‎Parameters in TSQLQuery.SQL
• curprev 11:3211:32, 21 January 2012‎ BigChimp talk contribs‎ 13,066 bytes +887‎ →‎Parameters in TSQLQuery.SQL: Added example; review welcome
• curprev 11:2211:22, 21 January 2012‎ BigChimp talk contribs‎ 12,179 bytes +198‎ →‎TSQLQuery.InsertSQL, TSQLQuery.UpdateSQL and TSQLQuery.DeleteSQL: Basic Use of Parameters: Excamples didn't match description about parameters
• curprev 11:1511:15, 21 January 2012‎ BigChimp talk contribs‎ m 11,981 bytes +1‎ →‎TSQLQuery.SQL: Basic SQL Customization
• curprev 11:1411:14, 21 January 2012‎ BigChimp talk contribs‎ 11,980 bytes +1,348‎ →‎TSQLQuery.InsertSQL, TSQLQuery.UpdateSQL and TSQLQuery.DeleteSQL: Basic Use of Parameters
• curprev 10:4710:47, 21 January 2012‎ BigChimp talk contribs‎ m 10,632 bytes +41‎ →‎TSQLQuery.SQL: Basic SQL Customization

8 July 2011

• curprev 09:3909:39, 8 July 2011‎ Kirkpatc talk contribs‎ 10,591 bytes 0‎ →‎TSQLQuery.SQL: Basic SQL Customization
• curprev 09:3809:38, 8 July 2011‎ Kirkpatc talk contribs‎ 10,591 bytes −3‎ →‎General

18 May 2010

• curprev 17:5417:54, 18 May 2010‎ Abeomega talk contribs‎ m 10,594 bytes −79‎ Take away unverified assumption
• curprev 15:3315:33, 18 May 2010‎ Abeomega talk contribs‎ 10,673 bytes +2,253‎ No edit summary

17 May 2010

• curprev 21:1121:11, 17 May 2010‎ Abeomega talk contribs‎ 8,420 bytes +3,140‎ No edit summary

7 July 2008

• curprev 11:2211:22, 7 July 2008‎ Iskraelectrica talk contribs‎ 5,280 bytes +27‎ No edit summary

20 June 2008

• curprev 16:2516:25, 20 June 2008‎ Swen talk contribs‎ m 5,253 bytes 0‎ →‎General: typo
• curprev 15:3015:30, 20 June 2008‎ Michael talk contribs‎ 5,253 bytes +669‎ →‎General
• curprev 15:2415:24, 20 June 2008‎ Michael talk contribs‎ 4,584 bytes +22‎ →‎General
• curprev 15:2315:23, 20 June 2008‎ Michael talk contribs‎ 4,562 bytes +84‎ →‎General
• curprev 15:2015:20, 20 June 2008‎ Michael talk contribs‎ 4,478 bytes +105‎ →‎General
• curprev 15:1615:16, 20 June 2008‎ Michael talk contribs‎ 4,373 bytes +1,534‎ →‎Primary key fields
• curprev 14:5614:56, 20 June 2008‎ Michael talk contribs‎ 2,839 bytes +1,291‎ No edit summary

3 February 2008

• curprev 19:5619:56, 3 February 2008‎ Kirkpatc talk contribs‎ 1,548 bytes −1‎ No edit summary

1 February 2008

• curprev 19:3019:30, 1 February 2008‎ Kirkpatc talk contribs‎ 1,549 bytes +936‎ No edit summary
• curprev 01:3901:39, 1 February 2008‎ Kirkpatc talk contribs‎ 613 bytes +1‎ No edit summary

30 January 2008

• curprev 19:1219:12, 30 January 2008‎ Kirkpatc talk contribs‎ 612 bytes +612‎ 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...