Artifact
26037273c4d9610d217181370648e05858d01bb5d829e71865a99f6fbdcbbf0b:
Ticket change
[26037273c4]
- New ticket [38d73b590f]
Retrieving something comparable to ResultSetMetaData (JDBC) with TDBC.
by
holgerjakobs
2019-10-22 15:32:55.
D 2019-10-22T15:32:55.135
J foundin 8.6
J icomment Using\sJDBC\s(Java)\salways\sprovides\sa\slot\sof\sinformation\sabout\sthe\sresult\sof\sa\squery.\sThis\sis\ssometimes\scrucial,\si.\se.\sto\sknow\swhether\sto\sdisplay\sthe\sresult\sof\sa\scolumn\sleft\sflush\s(strings)\sor\sright\sflush\s(numbers).\r\n\r\nTDBC\s(Tcl\sdatabase\sconnectivity)\sseems\sto\slack\sthis\scapability.\sWhile\sit\sis\strue\sthat\swithin\sTcl\s"everything\sis\sa\sstring",\sit\sis\ssometimes\snecessary\sto\sknow\swhether\ssomething\sis\snumeric,\sdate,\sstring\sor\swhatever\skind\sof\sdata\stype\sa\sresult\scolumn\shas.\r\n\r\nIt's\seasy\sto\sask\sthe\sdatabase\sfor\sthe\scolumn\stypes\sof\sexisting\stables\sor\sviews,\sbut\san\sindividual\squery\swith\scomputed\scolumns\scan\sdeliver\svalues\sof\stypes\sunknown\sbeforehand.\sAn\seasy\sexample\sfor\sthis\sis\sSELECT\scurrent_timestamp;\s-\sthere\sis\sno\stable\syou\scould\sask\sfor\sthe\sdata\stype.\r\n\r\nSince\sI\swas\sso\sdesperate,\sI\screated\sa\stemporary\sview\swith\sthe\sSELECT\sstatement\sand\sasked\sthis\stemporary\sview\sfor\sits\scolumn\sinformation.\sBut\sthis\sworkaround\sshould\sreally\snot\sbe\snecessary.\r\n\r\nI\swouldn't\sregard\sit\sa\sproblem\sif\sthe\sdata\stypes\swere\sdifferent\sdepending\son\sthe\sdatabase\ssystem.\sSince\sthere\sare\sso\smany\sdifferent\sdatatypes,\ssome\sof\swhich\sare\snot\savailable\sin\sother\ssystems,\swe\shave\sto\sdeal\swith\sdifferences\sanyway.
J login holgerjakobs
J mimetype text/x-fossil-wiki
J private_contact 4ff541fc163b2199651cb4c111fd70b40e5e45b6
J severity Important
J status Open
J title \sRetrieving\ssomething\scomparable\sto\sResultSetMetaData\s(JDBC)\swith\sTDBC
J type Feature_Request
K 38d73b590fdcecad2baaf8597fb860cd6d218b33
U holgerjakobs
Z d6a17ee5502c5054795ff081a9b3e0a0
