Home » Developer & Programmer » Forms » How to make a called form starts executing a query .?
How to make a called form starts executing a query .? [message #84473] Thu, 18 March 2004 13:40 Go to next message
Carlos Carrizosa
Messages: 6
Registered: March 2004
Junior Member
I have a block with a few fields of a record. I want to call another form to update that record, so I need the new form initiates showing the same fields of the calling form. How do I call the new form to do this ? How I can to call the new form sending the actual fields as parameters to the new form ?
Re: How to make a called form starts executing a query .? [message #84493 is a reply to message #84473] Tue, 23 March 2004 01:22 Go to previous message
simi
Messages: 23
Registered: August 2002
Junior Member
You can call the form using Call_Form

1. Create a Form Parameter named A in both called and calling forms.
2. Create a parameterlist with the parameter A as an element
3. Pass the parameterlist while calling the form using call_form.
4. In the called form before issuing a query use the parameter A in query where condition
Ex. Where Empno=:parameter.A;

If you are not comfortable with parameterlist mail me & I will send some sample code

Thanks
Previous Topic: SQL Net easy configuration
Next Topic: Urgent: Committing specific blocks in Forms
Goto Forum:
  


Current Time: Sat Apr 20 11:33:39 CDT 2024