oracle 6i form foreground color problem.
Dear sir,
i am omprakash, working as ERP(oracle form 6i) programmer for simplex engg. foundry work ltd. bhilai. I have some problem , i would like to resolve it by you.plz help me....
1) I am working on hr module , i have made student attendance form, where attendance is enter and marked default attendence by procedure. the user wants to display absent data ie. 'A' in the red foreground color into form(version is oracle form 6i). whenever 'A' is enter into the form it appears in red color.Is it Possible to do this? if yes then how?
2) I am also working on student information system, where i have to keep all the student details along with certficate doc(like 10th, 12th, tc etc . certificate) as a scan file. the user want to display scanned file along with student id,name,address..etc. but user will use radio button in the form by selecting it they want to display the scanned file of a particular student. i am not able to choose the way, how can i do this job in convenient.
can you plz reply me by email to my id. my emailid is..
sahu.omprakash25@gmail.com,edp@simplexengg.in
its an urgent..plz reply me soon.
thanx.
waiting for reply....
Software/Hardware used:
oracle form and reports 6i
Software/Hardware used:
oracle form and reports 6i
ASKED:
September 30, 2011 7:19 AM
UPDATED:
March 31, 2012 12:56 AM
Answer Wiki:
For point number 1, you could use the SET_ITEM_PROPERTY or SET_ITEM_INSTANCE_PROPERTY built-in procedures to change the Foreground_Color property from the item's when-validate-item trigger.
For your second query, you could store the images in the database, or you could store the images in the file system and the path in the database. Both approaches have some pros and cons.
If you decide to store the images in the database, this question might offer some help:
<a href="http://itknowledgeexchange.techtarget.com/itanswers/how-to-insert-a-image-file-into-oracle-8i-database/">How to insert an image file into an Oracle 8i database?</a>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
