https://gestinux.net/mediawiki/index.php?title=TGQuery&feed=atom&action=historyTGQuery - Revision history2024-03-29T02:04:38ZRevision history for this page on the wikiMediaWiki 1.35.1https://gestinux.net/mediawiki/index.php?title=TGQuery&diff=1941&oldid=prevTintinux: Created page with " == Purpose == TGQuery is the only way used in Gestinux to display data from tables or Sql queries. You can drop a TGQuery on a form, to be used by a TGDbGrid. They are ..."2012-10-17T21:31:32Z<p>Created page with " == Purpose == TGQuery is the only way used in Gestinux to display data from tables or Sql queries. You can drop a TGQuery on a form, to be used by a <a href="/mediawiki/index.php?title=TGDbGrid" title="TGDbGrid">TGDbGrid</a>. They are ..."</p>
<p><b>New page</b></p><div><br />
== Purpose ==<br />
<br />
TGQuery is the only way used in Gestinux to display data from tables or Sql queries.<br />
<br />
You can drop a TGQuery on a form, to be used by a [[TGDbGrid]]. They are linked by a TDataSource in the usual way.<br />
<br />
You can also create dynamically a TGQuery. <br />
The Create constructor assign in one time the [[TGDbConnection]], and Sql code, and open the query.<br />
Currently, bind parameters can't be assigned before opening : include the values in the Sql query. <br />
<br />
When editing is requested, set the 3rd optional parameter to true : it will try to lock the retrieved record, <br />
If the record is already locked, a message is automatically displayed, allowing the user to wait or cancel.</div>Tintinux