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 ?
Ok, so now we are on the same page.
One option is to put a format mask on the field you are bringing the data into so not show the decimal places.
If you are reading the data into a character field that is a different matter.
Are you using the same webutil and version of jacob for both situations?
Your windows might be running a 32bit version and your Aix ends up running a 64-bit version, not that this would explain the issue.
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.