Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Column format

4 posts in General Discussion Last posting was on 2007-06-25 16:31:44.0Z
David Tittle Posted on 2007-06-22 16:38:40.0Z
Sender: 55c3.467bfaec.1804289383@sybase.com
From: David Tittle
Newsgroups: ianywhere.public.general
Subject: Column format
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <467bfb10.55cd.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 22 Jun 2007 09:38:40 -0700
X-Trace: forums-1-dub 1182530320 10.22.241.41 (22 Jun 2007 09:38:40 -0700)
X-Original-Trace: 22 Jun 2007 09:38:40 -0700, 10.22.241.41
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6085
Article PK: 2542

How do you reformat columns? I have some that have numeric
values and when I insert into them, commas are added (7,388)
I only what the numbers. I have looked in the options and
I can not find where to chane this. Any thoughts?

Thanks,

David Tittle


David Tittle Posted on 2007-06-22 16:44:51.0Z
Sender: 55c3.467bfaec.1804289383@sybase.com
From: David Tittle
Newsgroups: ianywhere.public.general
Subject: Re: Column format
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <467bfc83.560a.1681692777@sybase.com>
References: <467bfb10.55cd.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 22 Jun 2007 09:44:51 -0700
X-Trace: forums-1-dub 1182530691 10.22.241.41 (22 Jun 2007 09:44:51 -0700)
X-Original-Trace: 22 Jun 2007 09:44:51 -0700, 10.22.241.41
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6086
Article PK: 2543


> How do you reformat columns? I have some that have numeric
> values and when I insert into them, commas are added
> (7,388)
> I only what the numbers. I have looked in the options
> and I can not find where to chane this. Any thoughts?
>
> Thanks,
>
> David Tittle

I forgot, I am using SQL Anywhere 10


Jason Hinsperger Posted on 2007-06-25 13:18:53.0Z
From: "Jason Hinsperger" <NO_jason_hinsperger_SPAM@hotmail.com>
Newsgroups: ianywhere.public.general
References: <467bfb10.55cd.1681692777@sybase.com> <467bfc83.560a.1681692777@sybase.com>
Subject: Re: Column format
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
NNTP-Posting-Host: hinsperg-d620.sybase.com
X-Original-NNTP-Posting-Host: hinsperg-d620.sybase.com
Message-ID: <467fc0bd$1@forums-1-dub>
Date: 25 Jun 2007 06:18:53 -0700
X-Trace: forums-1-dub 1182777533 10.25.99.225 (25 Jun 2007 06:18:53 -0700)
X-Original-Trace: 25 Jun 2007 06:18:53 -0700, hinsperg-d620.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6091
Article PK: 2544

SQL Anywhere does not add formatting to numbers when they are stored. It is
your front end application that is formatting the numbers and adding the
separators. How are you viewing the data?

--
Jason Hinsperger
Product Manager
iAnywhere

SQL Anywhere Developer Community
http://www.ianywhere.com/developer

<David Tittle> wrote in message news:467bfc83.560a.1681692777@sybase.com...
>> How do you reformat columns? I have some that have numeric
>> values and when I insert into them, commas are added
>> (7,388)
>> I only what the numbers. I have looked in the options
>> and I can not find where to chane this. Any thoughts?
>>
>> Thanks,
>>
>> David Tittle
>
> I forgot, I am using SQL Anywhere 10


Chris Keating (Sybase iAnywhere) Posted on 2007-06-25 16:31:44.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating@iAnywhere.Dot.com>
User-Agent: Thunderbird 1.5.0.12 (Windows/20070509)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Column format
References: <467bfb10.55cd.1681692777@sybase.com> <467bfc83.560a.1681692777@sybase.com> <467fc0bd$1@forums-1-dub>
In-Reply-To: <467fc0bd$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: keating-dm20.sybase.com
X-Original-NNTP-Posting-Host: keating-dm20.sybase.com
Message-ID: <467fedf0$1@forums-1-dub>
Date: 25 Jun 2007 09:31:44 -0700
X-Trace: forums-1-dub 1182789104 10.25.99.119 (25 Jun 2007 09:31:44 -0700)
X-Original-Trace: 25 Jun 2007 09:31:44 -0700, keating-dm20.sybase.com
Lines: 27
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6099
Article PK: 2554

Sybase Central and DBISQL in SQL Anywhere do format numbers the way you
describe. The formating is done in SC and DBISQL but s not stored in the
database.
--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************

Sign up today for your copy of the SQL Anywhere Studio 10 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/downloads/software/sql_anywhere_intro.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************