Forms :: SQL Server In Stop Position?
May 25, 2011SQLserver in stop condition when i play it. it again stop
View 1 Replies
ADVERTISEMENT
Forms :: How To Position Center Customized Logon Screen In Web Forms
Nov 20, 2012I would like to Center Align application login page(Syslogin) oracle froms 11gr2. The below code is not working in forms 11g2, it's working in Forms 6i
PROCEDURE CenterWindow (win_name VARCHAR2) IS
w_mdi NUMBER;
h_mdi NUMBER;
w_win NUMBER;
h_win NUMBER;
[code]...
Forms :: Calendar LOV Position (x / Y) On 6i
Aug 1, 2011I have included a calender control in my form and its working fine.Now, my problem is how can I automatically place the calender next to the text-item (for example, "block.invdate")if the push button is pressed to call a calender.
View 1 Replies View RelatedServer Utilities :: Counting Position Of Data In Fixed Format?
Sep 5, 2010How the people in production counts the exact position of the data in fixed format of Sql*loader? Isn't it critical especially in a critical and having many column to be inserted.
View 6 Replies View RelatedForms :: How To Get Current Cursor Position In Oracle 10g Form
Feb 25, 2010I want to get current mouse cursor position dynamically,what should i do.
View 3 Replies View RelatedForms :: How To Handle Position / When Do You Want To Save Changes / Dialogue Box Appears
Jan 22, 2013I am working on Oracle apps. I have developed a custom screen. On the screen, if the user press 'F4' on final step, it will ask the dialogue..Do You want to save changes?
Yes No Cancel.
Even the user press the "Yes" , I want to check my own validation and commit when my validation get perfect.
Forms :: Customize Position Of ALERT Message On Screen As Per Requirement
Mar 19, 2010I am using Oracle developer Suite 10g, and i want to customize the position of ALERT message on the screen as per requirement.
View 4 Replies View RelatedForms :: Insert Value Into Text Field On Current Cursor Position?
Sep 30, 2013I need to copy some text value in to a multi-line text item on the current cursor position.
View 8 Replies View RelatedForms :: Setting Mouse Position And Restricting Checkbox Update?
Aug 9, 2010what name is used to reverence the mouse cursor in Forms. I am trying to state that if the user reaches the last record in a file and clicks the mouse on the empty record below that they will get a message saying they are at the last record (basically so it means they have to manually click an add record button before they can add a new record)
I currently have this:
IF :SYSTEM.LAST_RECORD = 'TRUE'
THEN
<something here> := :SYSTEM.LAST_RECORD;
MESSAGE('You are at the last record.');
ELSE
DOWN;
END IF;
Where i have <something here> is where i assume the refence for the mouse cursor should go, of which i dont know the name, am i correct?
Another thing is that I have a checkbox that is originally NO but when set to YES cannot be turned back to NO.
I have accomplished this by putting the following code in the WHEN_CHECKBOX_CHANGED trigger and it works fine. However it also updates the checkbox to NO and then back to YES, , as a result this brings up my Are you sure you want to update message. I originally thought that if i took out the :in_active := 'Y'; the FORM_TRIGGER_FAILURE would stop the checkbox being changed in the first place but this didnt appear to be the case. how to accomplish this without letting it update at all (perhaps put something in the WHEN_VALIDATE trigger?
DECLARE
return_alert number;
BEGIN
if :in_active = 'N' THEN
return_alert := SHOW_ALERT('checkbox_alert');
:in_active := 'Y';
RAISE FORM_TRIGGER_FAILURE;
END if;
END;
Forms :: Trigger That System Generate Position Against Total Marks?
Aug 26, 2011i have one project about school system.there is one column of total marks.and other one is position column.i want a trigger that system genrate the position against total marks. problem is this when total marks become equal for example 101 and 101 than position also same.but dont now what a trigger i write for this.here some example
if total marks 100 than position is 1stand if total marks 99 than position is 2ndbut third person is also same number in total marks column i mean 99 than in position column must write the 2nd
Forms :: How To Stop Going To Next Record If It Is Last One
Jan 31, 2012how to stop going to next record if it finds the last record. Because when i click my next button(it is the last record), i try to click my previous or first button but it won't go back, enter-query mode is the error message.
View 9 Replies View RelatedForms :: How To Stop System Message
Nov 3, 2010I have a form with multiple data block. When i want to query and go to next record then this displayed a message "Do you want save changes". But i would like to stop this message(i.e would not see the message) is it possible.
View 3 Replies View RelatedForms :: How To Stop From Inserting If Condition Not Met
Feb 7, 2010I have master detail datablocks. Master block is course and detail block is trainee. students can schedule their courses in a location at particular time.
lets assume student1 has scheduled course A1 in location LA1 from 9am to 12 pm. Now second student shouldn't be able to schedule same course at same time in same location. He can schedule at different time duration. or else same time duration but different location. Or same time, same location but different course.
so, what i did is, i wrote code in when-validate-record of trainee block to display a message saying " cannot schedule course.choose another time." if he try to insert same time duration or same location .
when i am trying to insert a record with time which is already scheduled and in same location, it displays the message but it is also saving the record. i don't want to save the record.
how should i do this? i tried to give ROLLBACK in this trigger but it doesn't accept. i tried pre-insert trigger also but it is also displaying message but saving the record
my code in when-validate-record is:
declare
cursor c1 is
select start_time,end_time,loc
from trainee
where cname=:course.cname;
[code].......
Server Administration :: Oracle Tracing At Stop And Start
Jan 20, 2012I need to add some kind of tracing in oracle 11g on linux when oracle starts and stops - as at times oracle takes a long time to start.
View 9 Replies View RelatedForms :: Stop Saving When Detail Record Is Null?
Feb 5, 2011I have master detail block just consider Forms A as a master and Forms B as a Detail,when my cursor is in form A i try to save the record, it is saved Form A and putting Form B data as null, i have to put a validation to stop this activity, i have to inform the user "Provide values for form B text item",
I created a post block trigger in form A
Begin
If (:FORM-B.TEXT1 is null)l or( :FORM-B.TEXT2 is null)
then
Message( 'provide value for FORM-B');
Message( 'provide value for FORM-B');
raise form_trigger_failure;
ELSE
NULL;
END IF
END;
Im Getting error message and navigation got stopped in last item of form A itself,i need to show error message and cursor control should move to first item of form -B which trigger i have to use for this.
Forms :: Uploading From Excel Stop When Open File?
Oct 21, 2010I'm uploading data from excel to our database using forms thru webutil. The problem is when I open the same excel file while the upload process is in progress, the uploading stops, BUT not displaying any error. Not even when I chick Help->Show error.
How could I prevent this error and how to trap and display error message?
Forms :: How To Stop Inserting Data If Commit Command Applied
Feb 17, 2010How Can We Stop to insert Data if Master Block have the record and detail block have no record but commit command applied i want that commit command can not be work if detail block have no record
View 7 Replies View RelatedForms :: Stop Responding When Pass From Master To Detail Block?
Jul 29, 2010I have problem with the form when i pass from the master to detail block the form stop working and it stops responding even if i am in the next detail block and i press tab to change from one record to another the form will say working and it stops responding.
View 2 Replies View RelatedPL/SQL :: How To Add New Column In Specific Position
Oct 14, 2012Say, a table has existing columns of A, B, D, and E.Now I want to add a new column C. But I want this column appear between B and D. I found that the newly added column always goes to the end of the table, i.e., A, B, D, E, C, instead of, A, B, C, D, E.
View 6 Replies View RelatedPL/SQL :: How To Add New Column To Specific Position
Jun 11, 2012How to add a new column to specified position in a existing table.I have using the oracle database 10g.This below code is not working in oracle 10 g
example:
ALTER TABLE EMPLOYEE ADD DEPT NUMBER FIRST:
ALTER TABLE EMPLOYEE ADD DEPT NUMBER AFTER JOB:
SQL & PL/SQL :: How To Write Text At Specified Position In File
Apr 11, 2013suppose i have a file named chk.txt and I have write 10 line in that file and i just want to write some text at line 5 or line first then how we can do this ?
View 3 Replies View RelatedSQL & PL/SQL :: Insert Comma After 3rd Position In String Value?
Jul 29, 2013I have to convert string 1234567 as 123,456,7 .
note 1234567 is a string.
PL/SQL :: Frame - Fetch Only 3rd Position From Column Customer-ts?
Dec 20, 2012have a column cstomer_ts from table customer, which contain records like:
"cstomer account"||"PRIVATE"||"foundation"
"cstomer account"||"PRIVATE"||"foundation of money"
"cstomer account"||"PRIVATE"||"Moneycost"now i want to fetch the third record from the column cstomer_ts which starts with 'Foundation'
i mean i want to fetch only 3rd postion frm the column cstomer_ts and tht should starts with 'Foundation'
SQL & PL/SQL :: How To Find Certain Rows From A Table According To Position Of Node In XMLTYPE
May 8, 2013I am having a table with content_id and content_data , content_data is of XMLTYPE
Content_data field in table is like below
<Content id="123234354" version="3">
<Definition>
<Code>ABC</Code>
[Code].....
i want to find in how many rows <Title> tag is after <XYZ> tag in the content_data field of the table?
Application Express :: Scroll To A Specific Position Within A Page?
Jan 30, 2013To branch & scroll to a specific position within a page (upon initial page load), is using a named anchor still the recommended/modern way to do this or is there some jQuery plugin goodness that does a better job?
View 2 Replies View RelatedApplication Express :: Adjusting Button Position On A Page
Feb 7, 2013i am trying to adjust the position of a button as below but i realized it gets a bit uneasy as i thought ,
style="position: absolute; left: 100px; top: 100px; "
SQL & PL/SQL :: Stop A Scheduler Job
Jun 1, 2011There is one maintenance job owned by SYSMAN running continuously. I want to stop that scheduler job .How ?
IS this the correct syntax to stop the running job ?
exec dbms_scheduler.stop_job(job_name=>'jobname');
Forms :: Stop Play Sound / Unable To Play Sound In Requested Sound Item
Feb 3, 2007I HAVE A FORM PLAYING SOUND WHEN IT'S OPENED AND WHEN I CALL ANOTHER FORM WITH SOUND ERROR "FRM-47201: Cannot play sound" -Unable to play the sound in the requested sound item. The sound output device may be busy. -SO I WONDER IF THERE IS ANY WAY TO STOP THE SOUND IN THE FIRST FORM WHEN ANY ACTION HAPPENED
View 8 Replies View RelatedSQL & PL/SQL :: Stop Loop On One Process?
Jul 3, 2010i want check some data from one process instead of last record
i.e
process data
uuu 1
2
3
4
ppp 1
2
3
4
[code].....
SQL & PL/SQL :: How To Stop Update In PK Column
Apr 1, 2012HOW TO STOP THE UPDATE IN PK COLUMN?
View 3 Replies View Related