Home » Developer & Programmer » Forms » problem with post keywords
problem with post keywords [message #481145] Mon, 01 November 2010 03:03 Go to next message
narang79
Messages: 137
Registered: June 2010
Senior Member
some time i see the problem when i used post keyword

in some form when data post after that if i trying
to enter another record then it shows following mes.

Record has been updated by another user
Requery to see the changes

what is the problem sir

Report message to a moderator

Re: problem with post keywords [message #481150 is a reply to message #481145] Mon, 01 November 2010 04:34 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
That means that there have been changes to the record in the DB that the form is unaware of (it knows they've happened but not what they are) - have you got any database triggers on the table?

Report message to a moderator

Re: problem with post keywords [message #481151 is a reply to message #481150] Mon, 01 November 2010 04:41 Go to previous messageGo to next message
narang79
Messages: 137
Registered: June 2010
Senior Member
no sir there is no any database trigger

Report message to a moderator

Re: problem with post keywords [message #481154 is a reply to message #481151] Mon, 01 November 2010 04:51 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
That's unfortunate since that's the simplest way of getting this error.
Does it happen on insert or update or both?
One particular table or several?
Do you get the error immediately after the post command?

Report message to a moderator

Re: problem with post keywords [message #481155 is a reply to message #481154] Mon, 01 November 2010 05:02 Go to previous messageGo to next message
narang79
Messages: 137
Registered: June 2010
Senior Member
i think it happens on update time

because first time when i enter a data & used post
after that when i press enter to entering new data
then it shows this message

i m using several tables

Report message to a moderator

Re: problem with post keywords [message #481156 is a reply to message #481155] Mon, 01 November 2010 05:15 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
And do you get the error when trying to modify all of those tables or one in particular?
What trigger is the post command in?

Report message to a moderator

Re: problem with post keywords [message #481157 is a reply to message #481156] Mon, 01 November 2010 05:33 Go to previous messageGo to next message
narang79
Messages: 137
Registered: June 2010
Senior Member
sir i have find out the solution but i cant understand

if i changed one block property Dml returning value
no to yes then problem resolved

but not find out the reason

Report message to a moderator

Re: problem with post keywords [message #481158 is a reply to message #481157] Mon, 01 November 2010 05:33 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
You've got database triggers on the table that block is based on.

Report message to a moderator

Re: problem with post keywords [message #481159 is a reply to message #481158] Mon, 01 November 2010 05:34 Go to previous messageGo to next message
narang79
Messages: 137
Registered: June 2010
Senior Member
no sir
no database trigger

Report message to a moderator

Re: problem with post keywords [message #481160 is a reply to message #481159] Mon, 01 November 2010 05:40 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
Yes database trigger.
The only reason the DML Return property exists is to return modifications made to records by database triggers to the form.
And if you have database triggers that change the record they fire on and that property is set to No you get the error you've encountered.
So if changing it to Yes fixes the problem then you must database triggers.

Report message to a moderator

Re: problem with post keywords [message #481163 is a reply to message #481160] Mon, 01 November 2010 05:54 Go to previous messageGo to next message
narang79
Messages: 137
Registered: June 2010
Senior Member
sir i cant understand

i think
i have done two changes first is this &
second post set on on clear detail trigger

Report message to a moderator

Re: problem with post keywords [message #481164 is a reply to message #481163] Mon, 01 November 2010 06:01 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
What don't you understand?

Why on earth would you put a post in on-clear-detail?

Report message to a moderator

Re: problem with post keywords [message #481165 is a reply to message #481164] Mon, 01 November 2010 06:04 Go to previous messageGo to next message
narang79
Messages: 137
Registered: June 2010
Senior Member
sir because i have no any database trigger

Report message to a moderator

Re: problem with post keywords [message #481166 is a reply to message #481165] Mon, 01 November 2010 06:12 Go to previous message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
How exactly are you checking if there are any database triggers?

Report message to a moderator

Previous Topic: WEBUTIL error in MOZILLA & CHROME
Next Topic: LOV scroll
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 04:59:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.