OraFAQ Forum: Forms » Problem in Date field

Home » Developer & Programmer » Forms » Problem in Date field

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

Problem in Date field [message #195360]

Thu, 28 September 2006 04:14

emadbsb
Messages: 334
Registered: May 2005
Location: egypt

Senior Member

Hii all

I have a strange problem

i have a field called Lastupdate
that field is changed to Sysdate when any update happen to the screen

i use the pre-update trigger on the block level
by that assign

:LASTUPDATE := SYSDATE;

my strange problem
that i had some forms works well with this code and make the update
and other forms doesnot work well with this code and doesnot make the update

Thanks for Everyone Helped and Helping me

[Updated on: Thu, 28 September 2006 04:15]

Report message to a moderator

Re: Problem in Date field [message #195485 is a reply to message #195360]

Fri, 29 September 2006 00:11

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Do not reference an item as ':itemname', always reference it as ':blockname.itemname'. I expect that in your other form you may have multiple blocks with the same column in more than one of them.

David

Report message to a moderator

Re: Problem in Date field [message #195494 is a reply to message #195485]

Fri, 29 September 2006 01:25

sandeepk7
Messages: 137
Registered: September 2006

Senior Member

Quote:

expect that in your other form you may have multiple blocks with the same column in more than one of them.

I suppose in this condition form will show compilation error.

There might me problem with dateformat.

Sandy

Report message to a moderator

Re: Problem in Date field [message #195500 is a reply to message #195494]

Fri, 29 September 2006 01:39

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

No, you will not get a compilation error. The item is valid as it exists in the form. Unfortunately, it may not be the item in which you are currently interested.

David

Report message to a moderator

Re: Problem in Date field [message #195504 is a reply to message #195500]

Fri, 29 September 2006 01:52

sandeepk7
Messages: 137
Registered: September 2006

Senior Member

Check out the screen shot. I made one same name item "TEST" in two different block. and when assigning value as :test :='a'; shows compilation error....
When assiging as :block2.test:='a'; is not shows any error..

Sandy

Attachment: as.bmp
(Size: 1.88MB, Downloaded 759 times)

Report message to a moderator

Re: Problem in Date field [message #195726 is a reply to message #195360]

Sun, 01 October 2006 21:31

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Only date is not updated? What about other fields that you've changed, it saved changes?

[Updated on: Mon, 02 October 2006 19:46]

Report message to a moderator

Re: Problem in Date field [message #196407 is a reply to message #195726]

Thu, 05 October 2006 04:07

shahidmughal
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan

Member

hi
you should use Post-Update Trigger

i surely say it will work because i also had this problems a few days ago.

regards

Muhammad Shahid Mughal

Report message to a moderator

Re: Problem in Date field [message #197064 is a reply to message #196407]

Mon, 09 October 2006 19:15

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you solved your problem?

David

Report message to a moderator

Previous Topic:	question from all the experts: Did we the change the key stroke?
Next Topic:	About graphics builder

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:36:21 CDT 2024