Thread: [Squirrel-sql-users] Re: How to remove commas from numeric results?
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Robert M. <rob...@gm...> - 2006-05-15 23:20:46
|
Eric, No problem. File->Global Preferences->Data Type Controls At the bottom of the tab there is a section covering "FLOAT, REAL, DOUBLE..= ." Be sure to pick "Use default format" We should probably have a FAQ item for this :) Rob On 5/15/06, Zarbock, Eric <Eri...@de...> wrote: > Hello Rob, > > Regret having to ping your inbox again. No rush on a reply. > > I have some 16 digit numbers from Oracle, using thin client. They > appear in Results with commas every 3 digits, which I have to manually > remove before pasting the value elsewhere. I've spent most of an hour > looking, do you know of a way to dispense with the commas? > > Thanks again, > > Eric Zarbock > |
From: Robert M. <rob...@gm...> - 2006-05-16 14:38:30
|
On 5/16/06, Zarbock, Eric <Eri...@de...> wrote: > :) > > Thanks. However, no luck here. Is my tab different because it's the > oracle thin client? I tried the 'Display as string' options... > There is a scrollbar on the right side of the dialog. If you scroll down, = you should see a section covering "FLOAT, REAL, DOUBLE..." data types. Rob |