|
a4d7f2a64f |
2010-04-17 22:32:56
|
Documentation
|
Open
|
|
documentation for statement getSql missing
|
The statement object has a method "getSql" which is not document:
<nowiki>
<p>set statement [$db_name prepare {select PATH_ID from PATHS where PATH=:path and parent_id is null}]
<p>::oo::Obj943372::Stmt::10
<p>(bin) 71 % $statement getSql
<p>select PATH_ID from PATHS where PATH=:path and parent_id is null
<p>(bin) 72 %
</nowiki>
|
|
a2ad232bf6 |
2010-04-17 22:51:05
|
Feature_Request
|
Open
|
|
feature request: add a getSql method to the resultset object
|
The statement object currently has an (undocumented) method yielding the underlying sql statement used for the construction of the specific statement object. (using bind variables notation).
request: add a similar method for the resultset object, showing the substituted values.
Using the example from the man page:
<nowiki>
<p>package require tdbc::sqlite3
<p>tdbc::sqlite3::connection create db phonebook.sqlite3
<p>set statement [db prepare {
<p> select phone_num from directory where first_name = :firstname and last_name = :lastname
<p> }]
<p>set firstname Fred
<p>set lastname Flintstone
<p>
<p>$statement getSql gives:
<p><i> select phone_num from directory where first_name = :firstname and last_name = :lastname </i>
<p>
<p>set rs [$statement execute]
<p><b>Request:</b>
<p>$rs getSql would give:
<p> <i>select phone_num from directory where first_name = 'Fred' and last_name = 'Flintstone' </i>
<p>
<p>
<p><b>Motivation:</b> this feature would be very helpfull in debugging..
</nowiki>
|
|
d1ad7f4948 |
2017-12-15 21:48:27
|
Code_Defect
|
Open
|
not_specified
|
odbc::sqlite table subcommand has trailing space in type value
|
|
b6ac73ed3b |
2012-11-29 16:25:04
|
Feature_Request
|
Open
|
|
tdbc::sqlite3 does not return described error states
|
|
05d96953e1 |
2012-11-29 16:33:41
|
Feature_Request
|
Open
|
tdbc::sqlite3
|
tdbc::sqlite3 does not support schematas
|
|
fbcd8d40f1 |
2015-04-27 00:58:31
|
Code_Defect
|
Open
|
not_specified
|
tdbc consults INFORMATION_SCHEMA without filtering for the target table's schema (foreignkeys, primarykeys methods affected)
|
|
6af4223559 |
2015-07-08 14:55:44
|
Code_Defect
|
Open
|
not_specified
|
if [package require tdbc::*] fails to load a DLL, it should clean up
|
|
907989fb78 |
2015-11-19 04:01:26
|
Code_Defect
|
Open
|
|
tdbcpostgres.tcl namespace eval
|
|
0302d63e13 |
2017-02-22 02:07:26
|
Documentation
|
Open
|
|
documentation of tdbc::statement paramtype is incorrect
|
|
6827edbee9 |
2018-04-25 08:10:59
|
Code_Defect
|
Open
|
tdbc::odbc
|
incorrect value returned from tdbc::odbc
|
|
d6c4db2556 |
2019-08-30 08:19:16
|
Build_Problem
|
Open
|
tdbc
|
makefile.vc: compile tdbcStubLib.c with -DTCL_USE_STUBS to not make tdbcodbc.dll dependent on tcl86t.dll
|
|
38d73b590f |
2019-10-22 15:32:55
|
Feature_Request
|
Open
|
|
Retrieving something comparable to ResultSetMetaData (JDBC) with TDBC
|
|
1a26b401c2 |
2020-02-07 11:25:21
|
Documentation
|
Open
|
|
tdbc::connection documentation missing text for tables and columns commands
|
|
41bc4f77ba |
2020-02-07 11:27:47
|
Documentation
|
Open
|
|
Documentation for tdbc::mysql contains extraneous commands in synopsis
|
|
219e90475a |
2023-06-23 06:47:39
|
Code_Defect
|
Open
|
|
pkgIndex.tcl for non-shared build
|
|
2e1e5de4e1 |
2023-12-15 18:53:03
|
Build_Problem
|
Open
|
|
configure warnings in tcl/pkgs setting
|