OraFAQ Forum: Forms » Uploading an excel file using webutil in AIX

Home » Developer & Programmer » Forms » Uploading an excel file using webutil in AIX

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Uploading an excel file using webutil in AIX [message #582413]

Thu, 18 April 2013 04:27

sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore

Member

Hi,

When i am uploading data in an excel file to my Forms(Windows) the screen works fine but when i am uploading the same excel file to my forms in AIX(Where the application is running) the data is uploaded with decimal points
The field is a char type and no format mask is set.
Eg:
Actual data: In Form(Windows) In Form (AIX)
4080026 4080026 4080026.0

Can anyone please help me understand why this could be happening.

Report message to a moderator

Re: Uploading an excel file using webutil in AIX [message #582415 is a reply to message #582413]

Thu, 18 April 2013 04:33

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

the data is uploaded with decimal points

Please, run a SELECT statement in SQL*Plus that proves that. Also, post description of that table and indicate which column contains that "faulty" data.

Report message to a moderator

Re: Uploading an excel file using webutil in AIX [message #582418 is a reply to message #582415]

Thu, 18 April 2013 04:45

sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore

Member

Hi,
My concerns are with the data that is shown on the screen to the user.
PFA screenshots.

AIX

WIN

[Updated on: Thu, 18 April 2013 04:54]

Report message to a moderator

Re: Uploading an excel file using webutil in AIX [message #582421 is a reply to message #582418]

Thu, 18 April 2013 05:00

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Sorry, I can't view these images (proxy settings, I guess) (what are "PFA screenshots?"). Could you upload and attach them to your next message (click "reply" button right below the message and upload these images).

Also, I suppose I asked something im my previous message. How come you didn't do what I told you to?

Report message to a moderator

Re: Uploading an excel file using webutil in AIX [message #582423 is a reply to message #582421]

Thu, 18 April 2013 05:14

sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore

Member

I have attached a word document in which you can see two screenshots(One AIX, One Windows)
I had linked two images and that why i said PFA(Please find attached) anyways..
I understood that you wanted me to show that faulty data is getting inserted into the table, and you wanted me to show that using a select statement. But my issue is not with respect to the data that is getting inserted but the data that is displayed on the screen. If you see the screen shots i think you will get clarity about what i am trying to explain.

Thanks & Regards,
Sankalp

Attachment: screenshot.JPG
(Size: 168.36KB, Downloaded 711 times)

[Updated on: Thu, 18 April 2013 05:19]

Report message to a moderator

Re: Uploading an excel file using webutil in AIX [message #582472 is a reply to message #582423]

Thu, 18 April 2013 11:52

sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore

Member

I have figured out the portion where i am having issue:
Scenario:
I am reading a string(123456) from excel using the code
Client_OLE2.get_char_property(cell,'Value') ;
In windows this resulting value is 123456 but in AIX it is 123456.0

I am reading this into a character field.

Issue:
The value i am reading from the excel can be number or character i mean it could be either '123456' or 'abcdef'
If i use Client_OLE2.get_num_property(cell,'Value'); then the value returns without decimal, but i can not use this code when there is an character in excel.

Report message to a moderator

Previous Topic:	Performance between Oracle Forms 6i and Forms 10g ?
Next Topic:	Changing LOV based on some other text item

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 05:17:01 CDT 2024