Home » Developer & Programmer » Forms » Enter Query/Execute Query
Enter Query/Execute Query [message #275795] Mon, 22 October 2007 13:24 Go to next message
ORAGENASHOK
Messages: 240
Registered: June 2006
Location: Chennai
Senior Member
Hi,

I am created master/detail form i want to do the transaction with automatically with using large queries, So i need to know how the enter query/execute query will work at the run time of the form.

I want forms as in enter query mode when user enter some particular key (eg: F4) then execute with the other key value (eg : ctrl+F9) with the user entered valid data in any of the field in the form.

Can any one help me.

Cheers
Ashok

Report message to a moderator

Re: Enter Query/Execute Query [message #275805 is a reply to message #275795] Mon, 22 October 2007 14:34 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What is this?
Quote:

i want to do the transaction with automatically with using large queries
What are "large queries"?

What is this? Sounds like WHEN-VALIDATE-ITEM trigger:
Quote:

... with the user entered valid data in any of the field in the form.


Now, do you have a problem, or do you expect to have a problem? Basically, a default master-detail forms does everything like a charm - it doesn't require any further coding. So ... could you, please, explain it a little bit more?

Report message to a moderator

Re: Enter Query/Execute Query [message #275850 is a reply to message #275795] Tue, 23 October 2007 01:10 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
To validate an item that you use in a query you have to set 'Fire in Enter-Query Mode' to 'Yes' for the 'when-validate-item' trigger on that item.

David

Report message to a moderator

Previous Topic: minimize network traffic
Next Topic: alert problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 09 02:20:07 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.