Home » Developer & Programmer » Forms » commit problem
commit problem [message #206911] Sat, 02 December 2006 03:44 Go to next message
Messages: 16
Registered: October 2006
Location: izmir
Junior Member

i have pre insert trigger that i controled null item... if item has not a data i showed message besides i have key_commit that has message if form_success then but it doesnt work .when i put the null data in item message work after that second message shows if form_success then message('') .. can anybody help me
Re: commit problem [message #206919 is a reply to message #206911] Sat, 02 December 2006 04:36 Go to previous messageGo to next message
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I believe there are capital letters along with punctuation signs on your keyboard. Why don't you use them?

There was a writer in my country who used to write sentences half a page long, so you had to be very concentrated to figure out what he was talking about.

But, I guess your problem has nothing to do with literature or poetry, so you should perhaps try to explain it as clear as possible. Reading all you have written in one sentence is, well, difficult.

So, what id your problem, exactly?
Re: commit problem [message #207053 is a reply to message #206911] Mon, 04 December 2006 00:45 Go to previous message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Do VALIDATION in the VALIDATION triggers. Leave Pre-Insert for key field data population. This is what the documentation says was the purpose for their creation.

Just move your 'IS NULL' validation to either the When-Validate-Item trigger of the field in question or to the When-Validate-Record trigger of the block.

Yes. Please use punctuation and the spell checker.


[Updated on: Mon, 04 December 2006 00:47]

Report message to a moderator

Previous Topic: state where no record match LOV
Next Topic: FRM-40735
Goto Forum:

Current Time: Sun Aug 20 01:09:46 CDT 2017

Total time taken to generate the page: 0.45936 seconds