Home » Developer & Programmer » Forms » why the last value in custom forms showing with symbol (11.5.10.2)
why the last value in custom forms showing with symbol [message #287107] Tue, 11 December 2007 01:48 Go to next message
ramisetti1
Messages: 30
Registered: January 2007
Member
Hi

recently I transfered data through backend by sqlloader
here the data is getting populate in custom forms but different symbol is coming along with last value of the form (tab pages also)

For giving better Idiea about problem Here I am attaching screen shots of form with values and symbol

because of this symbol along with last value it giving no data found error in all pages and data not populating in calculation fields(formula)

please help me
\
regards suresh
Re: why the last value in custom forms showing with symbol [message #287149 is a reply to message #287107] Tue, 11 December 2007 03:37 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Due to restrictions and/or unwillingness to open a DOC file from an unknown source, could you attach an image instead of the DOC file? Use JPG or PNG format, please.
Re: why the last value in custom forms showing with symbol [message #287159 is a reply to message #287149] Tue, 11 December 2007 04:33 Go to previous messageGo to next message
ramisetti1
Messages: 30
Registered: January 2007
Member
thank you for reply

here I attaching screen shot in jpeg formate

please observe the last value in form
you will find symbol along with last value

regards
suresh./fa/3553/0/
Re: why the last value in custom forms showing with symbol [message #287160 is a reply to message #287159] Tue, 11 December 2007 04:38 Go to previous messageGo to next message
ramisetti1
Messages: 30
Registered: January 2007
Member
second sreen shot
check the value which is rounded with line./fa/3554/0/
Re: why the last value in custom forms showing with symbol [message #287161 is a reply to message #287160] Tue, 11 December 2007 04:39 Go to previous messageGo to next message
ramisetti1
Messages: 30
Registered: January 2007
Member
third screen shot

check the rounded value./fa/3555/0/
Re: why the last value in custom forms showing with symbol [message #287163 is a reply to message #287160] Tue, 11 December 2007 04:48 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:

recently I transfered data through backend by sqlloader

Where did you take the original data from? Are code pages of your previous data storage (another database?) and your current database the same?

Would it be possible for you to post several lines (or even attach a sample TXT file) which represent data you showed us via JPG images? Also, how does output of a SELECT statement look like, when executed in SQL*Plus? I'd like to see the result of something as
SELECT * 
FROM hf_house_and_car_cost
WHERE employee_number = 4845;
Re: why the last value in custom forms showing with symbol [message #287165 is a reply to message #287163] Tue, 11 December 2007 05:16 Go to previous messageGo to next message
ramisetti1
Messages: 30
Registered: January 2007
Member
HI
Here I am Attaching exel files and toad screen shots
please find it

If we observe the excel file ,the last value is showing one step above the allignment of remaining values
please check it

it might be the problem please check it

how to reduce that space

I loaded the data from .csv files to tables
Re: why the last value in custom forms showing with symbol [message #287166 is a reply to message #287165] Tue, 11 December 2007 05:19 Go to previous messageGo to next message
ramisetti1
Messages: 30
Registered: January 2007
Member
./fa/3556/0/
Re: why the last value in custom forms showing with symbol [message #287167 is a reply to message #287166] Tue, 11 December 2007 05:21 Go to previous messageGo to next message
ramisetti1
Messages: 30
Registered: January 2007
Member
screen shot 1./fa/3557/0/
  • Attachment: 1.JPG
    (Size: 244.05KB, Downloaded 223 times)
Re: why the last value in custom forms showing with symbol [message #287168 is a reply to message #287167] Tue, 11 December 2007 05:24 Go to previous messageGo to next message
ramisetti1
Messages: 30
Registered: January 2007
Member
results in exel file for screen shot 1
  • Attachment: result2.xls
    (Size: 7.00KB, Downloaded 179 times)
Re: why the last value in custom forms showing with symbol [message #287169 is a reply to message #287168] Tue, 11 December 2007 05:25 Go to previous messageGo to next message
ramisetti1
Messages: 30
Registered: January 2007
Member
screen shot 2./fa/3559/0/
  • Attachment: 2.JPG
    (Size: 243.05KB, Downloaded 228 times)
Re: why the last value in custom forms showing with symbol [message #287170 is a reply to message #287169] Tue, 11 December 2007 05:26 Go to previous messageGo to next message
ramisetti1
Messages: 30
Registered: January 2007
Member
results in exel file for screen shot 2
  • Attachment: RESULT3.xls
    (Size: 7.00KB, Downloaded 150 times)
Re: why the last value in custom forms showing with symbol [message #287172 is a reply to message #287170] Tue, 11 December 2007 05:27 Go to previous messageGo to next message
ramisetti1
Messages: 30
Registered: January 2007
Member
results of xxhrms_loan_cost table
  • Attachment: result1.xls
    (Size: 7.50KB, Downloaded 152 times)
Re: why the last value in custom forms showing with symbol [message #287322 is a reply to message #287172] Tue, 11 December 2007 23:25 Go to previous messageGo to next message
ramisetti1
Messages: 30
Registered: January 2007
Member
I posted all the details
i didn't get any answere

please check this

If we save the toad results of query in to exel file
it is showing much space in a row for the table having symbol in forms than tables witout symbol in form

If you observe exel file you can get some idiea

regards
suresh
Re: why the last value in custom forms showing with symbol [message #287366 is a reply to message #287322] Wed, 12 December 2007 01:41 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Unfortunately, due to restrictions and/or unwillingness to download and open XLS files from the Internet, some Forum members can not see what you've attached. That's why I asked you to post result of SQL*Plus session (which can be attached as TXT file or simply pasted here). Make sure to use [code] tags.

Also, you might want to read the OraFAQ Forum Guide which will help you to properly write a message, and other forum members to view what you've written.
Re: why the last value in custom forms showing with symbol [message #287379 is a reply to message #287366] Wed, 12 December 2007 02:08 Go to previous messageGo to next message
ramisetti1
Messages: 30
Registered: January 2007
Member
Hi here
I am attaching screen shots of excel sheets in JPG form
these excel screen shots are results of query (select * from table)
please find it

if you observe that exel screen shot
the row which showing more space (big boxes) is giving symbol in form from last value

the row which is fits perfectly not showing symbol

I think because of that space only it is giving symbol
how we can remove that space in table

regrads
suresh./fa/3569/0/
  • Attachment: Loan cost.JPG
    (Size: 119.70KB, Downloaded 190 times)
Re: why the last value in custom forms showing with symbol [message #287380 is a reply to message #287379] Wed, 12 December 2007 02:09 Go to previous messageGo to next message
ramisetti1
Messages: 30
Registered: January 2007
Member
it is giving symbol
./fa/3570/0/
Re: why the last value in custom forms showing with symbol [message #287406 is a reply to message #287380] Wed, 12 December 2007 03:09 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What is the result of the following query?
select other_cost_hra, length(other_cost_hra),
       trim(other_cost_hra), length(trim(other_cost_hra))
from xxhrms_house_cost
where employee_number = 4845;


Does this work, or does it return an error? If so, which one?
select to_number(other_cost_hra)
from xxhrms_house_cost
where employee_number = 4845;
Re: why the last value in custom forms showing with symbol [message #287473 is a reply to message #287406] Wed, 12 December 2007 05:54 Go to previous messageGo to next message
ramisetti1
Messages: 30
Registered: January 2007
Member
here I am attaching the results of first query./fa/3577/0/
Re: why the last value in custom forms showing with symbol [message #288923 is a reply to message #287473] Wed, 19 December 2007 01:15 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem? What IS the problem?

David
Previous Topic: how to run query in from
Next Topic: delete last n rows of a table
Goto Forum:
  


Current Time: Thu Dec 08 06:15:31 CST 2016

Total time taken to generate the page: 0.07950 seconds