Home » Developer & Programmer » Forms » Problem in Date field
Problem in Date field [message #195360] Thu, 28 September 2006 04:14 Go to next message
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 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: Problem in Date field [message #195494 is a reply to message #195485] Fri, 29 September 2006 01:25 Go to previous messageGo to next message
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
Re: Problem in Date field [message #195500 is a reply to message #195494] Fri, 29 September 2006 01:39 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: Problem in Date field [message #195504 is a reply to message #195500] Fri, 29 September 2006 01:52 Go to previous messageGo to next message
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 156 times)
Re: Problem in Date field [message #195726 is a reply to message #195360] Sun, 01 October 2006 21:31 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: Problem in Date field [message #197064 is a reply to message #196407] Mon, 09 October 2006 19:15 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Previous Topic: question from all the experts: Did we the change the key stroke?
Next Topic: Forms 6.0 Runtime Failure & Forms 6.0 runtime error-please help me (merged)
Goto Forum:
  


Current Time: Thu Dec 08 14:44:09 CST 2016

Total time taken to generate the page: 0.13119 seconds