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.
Actual data: In Form(Windows) In Form (AIX)
4080026 4080026 4080026.0
Can anyone please help me understand why this could be happening.
You didn't supply your version of Forms this is always required?
Also can you explain what you mean between Forms(Windows) and Forms(AIX)? Do you mean when run in Developer on windows as opposed to when run on the AS on AIX? Windows is always involved unless there is a version of Excel that runs natively on AIX ?
I have figured out the portion where i am having issue:
I am reading a string(123456) from excel using the code
In windows this resulting value is 123456 but in AIX it is 123456.0
I am reading this into a character field.
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.