|
From: Alexandre P. <Ale...@ei...> - 2017-06-16 04:47:49
|
Rizwan, Integer doesn't have fractional part. It won't have any separator. Sent from my iPhone On Jun 15, 2017, at 6:33 PM, rizwan Ishtiaq via Squirrel-sql-users <squ...@li...<mailto:squ...@li...>> wrote: Hi Gerd, is there any way not to have any type of separator on number field? practical need: Some time we need to copy, primary key (integer value) and paste it in query. we have to remove separator each time. Best Regards On Thursday, 15 June 2017, 17:14, Gerd Wagner <ger...@t-...<mailto:ger...@t-...>> wrote: Hi Max, how about using the standard format? It has no thousands separators but uses '.' as fraction separator. If so got menu File --> Global Preferences --> Tab 'Data Type Controls' --> Section 'FLOAT, REAL, DOUBLE, NUMERIC ... ' Gerd Am 13.06.2017 um 09:54 schrieb Massimo Re: > Hi all > > Actually i use Squirrel 3.7.1 with Oracle ad SQLSERVER Dbase, > > Numeric fields shown in data results after SELECT * FROM are displayed > with thousand separator... > > *Example 1* > > Immagine incorporata 1 > > Is possible display fields without thousand separator ? > > In the example above first row my desidered result value is > > 20170606101639 > > *Example 2* > > 123.456,78 --> Actual > > 123456,78 ----> Desidered > > > I've tried to check in general preferences, but nothing > > Any suggestions ? > > > Thank you for your support. > > -- > Ma > x > > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org<http://Slashdot.org>! http://sdm.link/slashdot > > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li...<mailto:Squ...@li...> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org<http://Slashdot.org>! http://sdm.link/slashdot _______________________________________________ Squirrel-sql-users mailing list Squ...@li...<mailto:Squ...@li...> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org<http://Slashdot.org>! http://sdm.link/slashdot _______________________________________________ Squirrel-sql-users mailing list Squ...@li...<mailto:Squ...@li...> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
