Forms :: Displaying Time In 10g?

Aug 2, 2010

I want to display time in reverse count down using oracle forms 10g.

View 3 Replies


ADVERTISEMENT

SQL & PL/SQL :: Displaying Date And Time

Aug 17, 2011

SQL> desc guide;
Name Null? Type
----------------------------------------- -------- ----------
GUIDE_ID NOT NULL NUMBER(20)
CHANNEL_ID NOT NULL NUMBER(5)
SHOW_DATETIME DATE
[code]....

when I run this query it only displays the date but no time.how to display it with the date and time?

View 2 Replies View Related

Forms :: Displaying Arabic In 10g

Sep 15, 2009

1-i have exported a database 9i with character set WE8MSWIN1252 which is her original character set;
2- i have created a new database 10G R2 with character set AL32UTF8;
3- i have imported the .dmp file to this new database with imp.exe 9i version configured with WE8MSWIN1252 character set;

-The problem is:

* when i use sqlplus, arabic data displays correctly but, in forms 10G, arabic data displays lick this ?E?? EC???IEC...... HOW CAN I CONFIGURE FORMS TO DISPLAY CORRECTLY ARABIC DATA?

View 3 Replies View Related

Forms :: Image Is Not Displaying

Jan 20, 2013

In my explorer/menu form there is a image item, I want to display company logo in this image item therefore I am using read_ image_ file ('c:application LOGO.jpg','JPG','IMAGE53') in WHEN_NEW_FORM_INSTANCE trigger but image isn't showing.

View 3 Replies View Related

Forms :: Displaying Icons In Web

Oct 17, 2004

I have problem in displaying icons in the push button during run time. Actually from few days i m trying to display icons at run time but with out any success.

i had made a simple push button and in its properties i had made the following changes

iconic=yes
icon filename=c:tempsave
the file save.GIF is saved under c:temp directory.

i had tried all the changes in registry.dat,orion file through the doc 203846.1 from metalink. Give me sample code step to step for showing a
push button with icon during run time. Also I tried the steps mentioned in the pdf document of

[URL].....

But it did not solve my problem. My icon file name is save.GIF , I wanted to know whether save.GIF file name convention is valid or not. Give the path from where I can get the icons used for web.

View 4 Replies View Related

Forms :: Message Is Not Displaying?

Feb 14, 2012

i got an error running my form. And when i re-run it again, the message at the bottom was nowhere to be found. How can i bring it back?

View 3 Replies View Related

Forms :: Displaying 2 Canvases Simultaneously?

Oct 8, 2010

I have created a form in which I have 2 canvases - content canvas and a tabbed canvas.

I have only 4 fields on the content canvas and the remaining on the tabbed canvas. My requirement is such that the tabbed canvas should appear below the content canvas when I run the form, i.e. the fields on the content canvas will be visible, and below them will be the tabbed canvas.

For the content canvas, I have set the viewportX and viewport Y position as (0,0), and for the tabbed canvas, I have set the viewportX and viewportY position as (0,100). However when I run the form, I only see the tabbed canvas and the area at the top where I should see the contents from the content canvas appear blank.

View 2 Replies View Related

Forms :: Displaying Image In Oracle 6i?

Apr 24, 2009

i am working with image. I have successfully stored image in oracle table. Now i want to display the stored image in oracle form 6i. There i unable to display the image although i have created the data block using the same table name as the data source.

View 9 Replies View Related

Forms :: Show_view Is Not Displaying X And Y Canvas

Sep 27, 2007

I have 3 canvases ---> X ( Content), Y ( Stack) and Z ( Stack) which has 3 blocks BX, BY, BZ resp.

WHEN-NEW-BLOCK-INSTANCE trigger of BX :
execute_query;
show_view('Y') ;
Now X and Y both canvases are displayed.
[code]....

Now only X is displayed. Canvas Y is vanished after a single blink. But I require both canvases as in initial stage.

View 5 Replies View Related

Forms :: Displaying Number Of Records With Condition

Jul 8, 2012

In form i call a record from database table through execute_query. i have lov on ITEM_NO

i want to display on that form, no. of records of ITEM_NO which i select from the list. like if i have 10 records with item_no which i select from list is must show 1/10.

if i press the down arrow it should show next record of the same item_no.

View 5 Replies View Related

Forms :: Page Wise Displaying Data

Apr 24, 2010

i want displaying the query data page wise.

i want place 4 buttons

1 for 1st page, 2nd for next page, 3rd nxt page and 4th for last page.

how can i do this through programming in oracle forms 10g.

give me the entire process of doing this.

i am waiting for your response.

View 9 Replies View Related

Forms :: Displaying Database Stored Documents In 6i

Apr 23, 2011

I want to display a pdf file (or other types of documents like word or excel) that is already stored in a blob column in the database, in a form control and be able to view the records one by one just like an image.

Is this possible? if so, how? If not, can you direct me to additional code, technology, package or whatever solution that can achieve the desired results. sing Oracle forms 6i and database 10g.

View 1 Replies View Related

Forms :: 6i Displaying Oracle Only Negative Sign

Nov 12, 2012

can you to display a field with negative value

S -- format mask display both sing + and -
MI -- format mask display negative sign at end
PR --Returns negative value in <angle brackets>. and Returns positive value with a leading and trailing blank.

I want the output should display only leading negative if the value is negative. I have used S99990.99 as format Mask. but need output should display only leading negative if the value is negative.

View 1 Replies View Related

Forms :: Data Not Displaying From Main Database?

Jul 25, 2012

on clicking select.show,while running the form data(DATE and APPLICANT_NO) is being accesed from local database but after uploading the form the data is not coming from main database,even if the data is present in the main database.

View 1 Replies View Related

Forms :: Displaying A Warning Message If No Detail Saved

Jul 25, 2011

I have 2 blocks, block 1 which is the master and block 2 which is the detail. Both block 1 and block 2 are multi record blocks. For my form I want to display a warning message to the user if they create a master block without also creating a detail.

View 2 Replies View Related

Forms :: Displaying Database Stored Image On Oracle 6i?

Oct 6, 2010

I have successfully Stored image file in Oracle 10g Database Table using Forms 6i. But I cannot retrieve that image and display on Forms 6i. Image Item on Form is not a database Item.

View 8 Replies View Related

Forms :: Multi Record Block Not Displaying Items

Feb 12, 2012

I want to ask what's wrong with my multi-record block.

When i click a node on my tree, it should display the records on it. For example, my root node is Sections, the parents are 1st sem and 2nd sem. In each sections in 1st sem, whenever i click a child node, it should display on display items. I have set its number of items displayed to 9. Since each sections have 9 subjects. The problem when i run it is that it displays many rows.

View 35 Replies View Related

Forms :: Records Not Displaying In Specific Text Item

Feb 14, 2012

I have for example two text items(number of records to display is set to 9). What I want is when i go to studentprofile block, it should automatically shows his subjects that are already taken up. the first text item is for 1st semester subjects and the other for 2nd semester.

here is the structure of my subjsec table:

ID number(1)
subj_code varchar2(10)
day varchar2(10)

and for subjects table:

subj_code varchar2(10)
description varchar2(50)
units number(1)
semester varchar2(10)

I restricted subjects that are in 1st sem. So i did something like this in my

DECLARE

CURSOR studgrade_cur IS
SELECT g.stud_id, g.grade, g.subj_code, s.description, s.units, s.semester
FROM studgrades g , subjects s
WHERE g.subj_code = s.subj_code
AND g.stud_id = :Studentprofile.student_id;

[Code]....

View 32 Replies View Related

Forms :: Prevent User From Navigating To Another Webpage By Displaying Dialog Box

Dec 8, 2010

how to know when a user was navigating away from the current open form (and I wanted to prevent the navigation with a dialog box) because they had entered a new URL in the address bar and were trying to navigate to it? I've seen a reference to it from an ADF perspective -> [URL]

but was wondering how to do it within Forms?

The reason for this is that i would want to prompt the user to confirm that they wanted to exit the form as potentially they would have a record (in the form) flagged as being updated and as such no other user (including themselves) could susbequently access it. So, I'm basically wanting to know if there is a way to catch the fact that the user is about to navigate to another web page.

Is it by using javascript and if so, how would it be implemented?

View 1 Replies View Related

Forms :: Displaying Records From A Table In Tabular Form With One Condition?

Mar 17, 2012

i want to display records from a table in tabular form with one condition.

i made a tabular form.and in WHEN-NEW-FORM-INSTANCE i write

DECLARE
CURSOR hascr IS
SELECT
BILL_ID,
BILL_DATE,
MAT_CODE,
PLACE_FROM,

[code]....

when i run the form its not showing any errors but displaying only one record.that is the first record whose bill_type is send to other store.

am i using the right trigger or my select statement has problem?

View 9 Replies View Related

Forms :: Displaying Tab Canvas On Content Canvas

Apr 23, 2012

I have tried enough to put Tab canvas on content canvas so that they can appear in the same window. I have tried on internet and unluckily find only

[URL].....

I didn't understand how to do it.

View 2 Replies View Related

Forms :: How To Change The Name In Run Time

Jul 20, 2010

I would like the change the name in run time find the attachment.

View 3 Replies View Related

Forms :: Hiding URL In Run Time

Aug 11, 2010

i am using oracle forms 10g, i have developed a form i am running that form it is showing in the web browser

[URL]..

can i hide the this 'frm/frmservlet/?from=xyz.fmx' information form others i don't wnat to show the form name at the run time and how hie this window at run time format of the first windows at run time

1st window===> Action Edit Query Block Record Field Help Window ORACLE

View 13 Replies View Related

Forms :: Time Calculation

Oct 20, 2011

Currently I am working on payroll system where I have to calculate employees working hours/late coming hours/early going hours against its roster which is defined in the beginning of every month/week.

In roster form user define shift of every employee like

Code Name Shift
7 Saad Nafees A - 09:00 17:00
492 Muhammad Nasir Shahzad B - 17:00 01:00
243 Muhammad Tahir C - 01:00 09:00

Roster table structure

code varchar2
name varchar2
Shift date
Remarks varchar2

shift table structure

code varchar2
timein date
timeout date
latetime date
Hdaytime date

Oracle stores both date and time information in date data type, suppose today user change shift timings from 17:00 to 17:30 or user change timein/timeout in attendance form then oracle will store current date with user define timings.

Now this is the main problem which I am facing because whenever you calculate difference between timein and timeout or compare with its roster then output comes wrong because oracle returns total no of hours whenever you minus two dates.

View 11 Replies View Related

Forms :: Set Run Time Initial Value Of Text Box

Jun 4, 2010

I want set run time initial value of text box...?

what property need to use for that..?

View 2 Replies View Related

Forms :: Military Time Validation?

Aug 12, 2010

I have a time field which i need to validate for military time. for example like e.g.1630. Time entered outside of military time range should not be permitted e.g. 1364, 2510.

View 4 Replies View Related

Forms :: How To Capture Return Value From LOV At Run Time

May 30, 2012

I have a field say field A which has to be enabled/disabled based on the return value from an LOV.

ex: if lov returns A then field A should be enabled anything other than A, then field A should be disabled.

Do we have any function to get the return value from LOV?

View 4 Replies View Related

Forms :: Idle Time Out In Oracle 10g

Sep 28, 2010

I have a query. Am using Oracle 10g forms. I want to set idle time for my Forms, i have modified the parameter FORMS_TIMEOUT and HEARTBEAT.

now its working fine . when the idle time reaches , application gets closed with the message "FRM-92101 ".

My question, i want to customize the message , something like

"Idle session time out, Application is going to be closed"

View 1 Replies View Related

Forms :: Access More Than One Form In The Same Time?

Feb 14, 2012

Is there any way to open 2 form or more and access them in the same time without close any form ?

View 2 Replies View Related

Forms :: Validate Time On Field

Aug 22, 2010

I have a varchar field and user will enter the time in that field as per the format HH:MI HOURS:MINUTES.Actually there is no control on this field and user is making mistakes like instead of HH:MI he is entering HH;MI.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved