Key: | Active | Review | Fixed | Tested | Deferred | Closed |
# | mtime | type | status | subsystem | title |
---|---|---|---|---|---|
comments | |||||
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: set statement [$db_name prepare {select PATH_ID from PATHS where PATH=:path and parent_id is null}] ::oo::Obj943372::Stmt::10 (bin) 71 % $statement getSql select PATH_ID from PATHS where PATH=:path and parent_id is null (bin) 72 % | |||||
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: package require tdbc::sqlite3 tdbc::sqlite3::connection create db phonebook.sqlite3 set statement [db prepare { select phone_num from directory where first_name = :firstname and last_name = :lastname }] set firstname Fred set lastname Flintstone
$statement getSql gives: select phone_num from directory where first_name = :firstname and last_name = :lastname
set rs [$statement execute] Request: $rs getSql would give: select phone_num from directory where first_name = 'Fred' and last_name = 'Flintstone'
Motivation: this feature would be very helpfull in debugging.. | |||||
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 |