Home » Developer & Programmer » Forms » Uploading an excel file using webutil in AIX
Uploading an excel file using webutil in AIX [message #582413] Thu, 18 April 2013 04:27 Go to next message
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.
Re: Uploading an excel file using webutil in AIX [message #582415 is a reply to message #582413] Thu, 18 April 2013 04:33 Go to previous messageGo to next message
Littlefoot
Messages: 19471
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.
Re: Uploading an excel file using webutil in AIX [message #582418 is a reply to message #582415] Thu, 18 April 2013 04:45 Go to previous messageGo to next message
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
http://i46.tinypic.com/121wq3d.jpg

WIN
http://i48.tinypic.com/35jimir.jpg

[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 Go to previous messageGo to next message
Littlefoot
Messages: 19471
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?
Re: Uploading an excel file using webutil in AIX [message #582423 is a reply to message #582421] Thu, 18 April 2013 05:14 Go to previous messageGo to next message
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

[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 Go to previous message
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.
Previous Topic: Performance between Oracle Forms 6i and Forms 10g ?
Next Topic: Changing LOV based on some other text item
Goto Forum:
  


Current Time: Thu Aug 21 02:10:04 CDT 2014

Total time taken to generate the page: 0.04998 seconds