 when_validate_item [message #194799] |
Mon, 25 September 2006 06:43  |
icemelid
Messages: 15
Registered: April 2005
Location: BARCELONA
|
Junior Member |
|
|
Hi,
Is it there a way to trigger query execution when
leaving a when_validate_item trigger ?
Tried execute_query, but it is not allowed in such
a trigger.
Thanks in advance
Ignasi
|
|
|
|
|
|
|
|
| Re: when_validate_item [message #195186 is a reply to message #194799] |
Wed, 27 September 2006 06:12  |
icemelid
Messages: 15
Registered: April 2005
Location: BARCELONA
|
Junior Member |
|
|
Hi,
Suppose you have a block based on a table:
1.- WHEN_NEW_BLOCK_INSTANCE do enter_query.
2.- WHEN_VALIDATE_ITEM on the first entering item do execute_query.
I could use KEY_NEXT_ITEM, but if you navegate with the mouse.
I could use a button, but I want more automatization.
Nobody seems to have the idea...
Thanks in advance.
|
|
|
|
| Re: when_validate_item [message #195199 is a reply to message #195186] |
Wed, 27 September 2006 06:47 |
RJ.Zijlstra
Messages: 104
Registered: December 2005
Location: Netherlands - IJmuiden
|
Senior Member |
|
|
Hi,
How do you know the first item here?
As a stupid user I just click somewhere in the block with the mouse and then ...sorry for your nice code in the when validate trigger on your first item, that happens to be not mine first item...
Regards
Rob Zijlstra
|
|
|
|
| Re: when_validate_item [message #195472 is a reply to message #195199] |
Thu, 28 September 2006 20:44 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
If you want a field to be a search only field, then create a control block, put the non-database item on it, don't let the users go to the other fields. Use that item as the 'Copy Value from Item' property of your query block's item and have a button that does a go_block and an execute_query. No tricks, nothing sexy.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
