OraFAQ Forum: Forms » system time

Home » Developer & Programmer » Forms » system time

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

system time [message #573907]

Fri, 04 January 2013 03:48

jocelyne
Messages: 34
Registered: December 2012
Location: lebanon

Member

how can i write a trigger to insert the system clock time in the oracle form?
any help please

Report message to a moderator

Re: system time [message #573908 is a reply to message #573907]

Fri, 04 January 2013 03:49

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Insert where? Into a form item? If so,

:block.item := sysdate;

Report message to a moderator

Re: system time [message #573909 is a reply to message #573908]

Fri, 04 January 2013 03:52

jocelyne
Messages: 34
Registered: December 2012
Location: lebanon

Member

sysdate just displays the date but i need to display the system time also into an item of course

Report message to a moderator

Re: system time [message #573910 is a reply to message #573909]

Fri, 04 January 2013 04:02

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Then provide format mask (for the item) you are interested in (such as 'dd.mm.yyyy hh24:mi')

Report message to a moderator

Re: system time [message #573911 is a reply to message #573910]

Fri, 04 January 2013 04:12

jocelyne
Messages: 34
Registered: December 2012
Location: lebanon

Member

thank you a lot for your help
i have another question
is it possible to authenticate the oracle form?

Report message to a moderator

Re: system time [message #573914 is a reply to message #573911]

Fri, 04 January 2013 04:25

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What do you mean by that?

Report message to a moderator

Re: system time [message #573916 is a reply to message #573914]

Fri, 04 January 2013 04:34

jocelyne
Messages: 34
Registered: December 2012
Location: lebanon

Member

i mean when i run the form i need to display a popup to enter a username and a password ( an authentication for the user not the one for the developper)

Report message to a moderator

Re: system time [message #573919 is a reply to message #573916]

Fri, 04 January 2013 04:40

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As every user should have his own username/password, you should create that user (CREATE USER ... IDENTIFIED BY ...). When he runs the form, he'll be prompted for username, password and database and then, he should enter these credentials. Basically, you don't have to do anything "special" because - without connecting to the database - you can't run the Forms application.

Report message to a moderator

Re: system time [message #573920 is a reply to message #573919]

Fri, 04 January 2013 04:50

jocelyne
Messages: 34
Registered: December 2012
Location: lebanon

Member

when i create a new user i have to login from the form builder then i have to run the form but the problem is that i need to login from the form not from the form builder

Report message to a moderator

Re: system time [message #573933 is a reply to message #573920]

Fri, 04 January 2013 06:39

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Which Forms version do you use?

Report message to a moderator

Re: system time [message #573939 is a reply to message #573933]

Fri, 04 January 2013 07:35

jocelyne
Messages: 34
Registered: December 2012
Location: lebanon

Member

oracle database 10g express edition version 9.0.4.0.19 (32 bits)

Report message to a moderator

Re: system time [message #573940 is a reply to message #573939]

Fri, 04 January 2013 07:39

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Please, pay attention to what you write. You put everything into a single line so I have to guess what you meant to say.

If I understood it:
- database is 10g XE
- Forms is 9.0.4.0.19
Is that correct?

If so, Forms (from 9i onwards) is web-based, so - in order for your users to use the application - you have to deploy it on the web. This is how: Oracle Application Server Forms Services - Deployment Guide 10g (9.0.4)

Report message to a moderator

Re: system time [message #573942 is a reply to message #573910]

Fri, 04 January 2013 08:44

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Littlefoot wrote on Fri, 04 January 2013 05:02

Then provide format mask (for the item) you are interested in (such as 'dd.mm.yyyy hh24:mi')

And to OP, you need to make the datatype DATETIME, not DATE.

Report message to a moderator

Re: system time [message #573948 is a reply to message #573942]

Fri, 04 January 2013 09:09

jocelyne
Messages: 34
Registered: December 2012
Location: lebanon

Member

thank you for the pdf but i still need some help to create and customize the sign in popup

Report message to a moderator

Re: system time [message #573961 is a reply to message #573948]

Fri, 04 January 2013 10:01

cookiemonster
Messages: 13968
Registered: September 2008
Location: Rainy Manchester

Senior Member

Are we supposed to guess what you need help with?

Report message to a moderator

Re: system time [message #573964 is a reply to message #573961]

Fri, 04 January 2013 10:09

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Jocelyne = Christiane (according to IP addresses) opened a new topic.

Report message to a moderator

Previous Topic:	radio button
Next Topic:	How to update record

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 31 02:34:53 CDT 2025