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.

Appeon 6.5:Issue with decimal numbers in embedded SQL

4 posts in Appeon (partner product) Last posting was on 2011-04-03 11:13:36.0Z
Angelo Z Posted on 2011-03-31 11:05:28.0Z
Sender: 681.4d945d64.1804289383@sybase.com
From: Angelo Z
Newsgroups: sybase.public.appeon
Subject: Appeon 6.5:Issue with decimal numbers in embedded SQL
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4d945ff8.6ca.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 31 Mar 2011 03:05:28 -0800
X-Trace: forums-1-dub 1301569528 10.22.241.41 (31 Mar 2011 03:05:28 -0800)
X-Original-Trace: 31 Mar 2011 03:05:28 -0800, 10.22.241.41
Lines: 28
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2660
Article PK: 13541

Hi,

My environment is the following:
. Windows 7 Pro
. Appeon 6.5 .NET
. PB 11.5 Build 4843
. Oracle 10g Xpress edition
. IE 8

I have the following code in my PB application:
/////
decimal{3} ld_value

SELECT col_value
INTO :ld_value
FROM table
WHERE col_code = "1111";
////

When the value in the database is 2.5 for col_value, I have
25 in ld_value after running the program.

In my Oracle database, the column "col_value" of table
"table1" is a NUMBER(9,3).

Can someone helps me to solve this issue ?

Regards.


Marco Meoni Posted on 2011-03-31 19:49:24.0Z
From: Marco Meoni <mail@marcomeoni.com>
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2.11) Gecko/20101013 Thunderbird/3.1.5
MIME-Version: 1.0
Newsgroups: sybase.public.appeon
Subject: Re: Appeon 6.5:Issue with decimal numbers in embedded SQL
References: <4d945ff8.6ca.1681692777@sybase.com>
In-Reply-To: <4d945ff8.6ca.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4d94dac4@forums-1-dub>
Date: 31 Mar 2011 11:49:24 -0800
X-Trace: forums-1-dub 1301600964 10.22.241.152 (31 Mar 2011 11:49:24 -0800)
X-Original-Trace: 31 Mar 2011 11:49:24 -0800, vip152.sybase.com
Lines: 44
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2661
Article PK: 21808

Hello.
Try this:

- open the file Web.config under C:\Inetpub\wwwroot\appeon\AEM on the
Appeon server machine
- look up for the "globalization" line and change as it follows:
<globalization requestEncoding="utf-8" responseEncoding="utf-8"
uiCulture="en-US" culture="en-US"/>
- save the file and restart IIS

Cheers,
M.

On 3/31/11 1:05 PM, Angelo Z wrote:
> Hi,
>
> My environment is the following:
> . Windows 7 Pro
> . Appeon 6.5 .NET
> . PB 11.5 Build 4843
> . Oracle 10g Xpress edition
> . IE 8
>
> I have the following code in my PB application:
> /////
> decimal{3} ld_value
>
> SELECT col_value
> INTO :ld_value
> FROM table
> WHERE col_code = "1111";
> ////
>
> When the value in the database is 2.5 for col_value, I have
> 25 in ld_value after running the program.
>
> In my Oracle database, the column "col_value" of table
> "table1" is a NUMBER(9,3).
>
> Can someone helps me to solve this issue ?
>
> Regards.