|
From: Colin B. <Col...@as...> - 2002-02-22 00:58:43
|
Hi Brad, net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet.setResultSet( ..) is where the result set gets read. I'd suggest overloading this function to take an additional parameter of type DataFormatter (or whatever you want to call it). DataFormatter would be a new class that would contain the formatters for dates, time, timestamps etc. Also nice would be formatting for the different numerics but these could be added later. I think that this formatting should be able to be specified at a "per session" basis so I think they should be specified on the SQL panel net.sourceforge.squirrel_sql.client.session.properties.SQLPropertiesPanel. This panel is used by both the New Sessions dialog and the Session Properties dialog. You'd need to store the new settings in the propeties class net.sourceforge.squirrel_sql.client.session.properties.SessionProperties and its associated BeanInfo class. I think that should be it. Thanks Col -----Original Message----- From: BradLyon [mailto:bra...@nt...] Sent: Wednesday, 20 February 2002 2:20 To: squ...@li... Subject: RE: [Squirrel-sql-develop] "Date" field display options? Colin: If you can point me to the relevant place (I want to be sure), I'll see if I can poke at it. At 11:24 AM 2/19/02 +1100, you wrote: >Hi Brad, > ><snip> >I need to see the date columns shown with seconds, etc. It's not happening >with the version I have (several months old). Are there more options for >showing dates in the most recent version? ></snip> > >Not yet but there should be. Whats needed (I think, feel free to disagree) >is replacing the getString() method with an appropriate getXXX() function >for date, time and timestamp and then using a DateFormat (or whatever its >called) to format that object for display. Both the New Session Properties >dialog and the Session Properties dialog should allow the user to specify >the format they want to see date, time and timestamp columns in. > >If you've got the time to make the changes to the latest CVS source and send >me a diff I'd really appreciate it, otherwise I'll add it to my todo list. > >Thanks >Col > >-----Original Message----- >From: BradLyon [mailto:bra...@nt...] >Sent: Sunday, 17 February 2002 1:52 >To: squ...@li... >Subject: [Squirrel-sql-develop] "Date" field display options? > > >I need to see the date columns shown with seconds, etc. It's not happening >with the version I have (several months old). Are there more options for >showing dates in the most recent version? > >Where in the code would I look to do this? I poked around a little, and it >looked like there was just a general toString called on object, but I might >have been looking at the wrong place. > >_______________________________________________ >Squirrel-sql-develop mailing list >Squ...@li... >https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop > >_______________________________________________ >Squirrel-sql-develop mailing list >Squ...@li... >https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop _______________________________________________ Squirrel-sql-develop mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop |
