Home » Developer & Programmer » Forms » passing a value at runtime (forms 6i)
passing a value at runtime [message #383384] Wed, 28 January 2009 11:06 Go to next message
georgebush
Messages: 7
Registered: December 2008
Junior Member
Hi,

I have a forms and I want pass a value at runtime from a command line so that form opens querying on that value.

eg

Running a form from command line,
ifrun60 fmname.fmx userid/pwd@servicename

If the form has a field say request_no,I want it open the form at runtime querying that field

which I expect something to be like this (doesn't work)
ifrun60 fmname.fmx userid/pwd@servicename request_no=10

I would like to to pass the value at runtime so that form open querying on that field.

Can anyone help me with it ?

Thanks,

PS>
I have attached the form , just in case if you would need it.

  • Attachment: req.fmb
    (Size: 412.00KB, Downloaded 1028 times)
Re: passing a value at runtime [message #383490 is a reply to message #383384] Thu, 29 January 2009 00:32 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you tried creating an item in the 'parameters' block called 'request_no' and then seeing if there is anything in it in the 'when-new-form-instance' trigger?

David
Re: passing a value at runtime [message #383860 is a reply to message #383384] Fri, 30 January 2009 15:01 Go to previous messageGo to next message
georgebush
Messages: 7
Registered: December 2008
Junior Member
Thanks a lot Martin.Tht information helped me.

I have another scenario where I am an sending email and I want to set up a link so that on clicking the link the form opens querying a specific record.

Do you know how that could be done?

Thank you once again.
Re: passing a value at runtime [message #384231 is a reply to message #383860] Mon, 02 February 2009 23:53 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Where is the link? What does it look like? Is the email calling the form or the form calling the email?

David
Re: passing a value at runtime [message #384341 is a reply to message #384231] Tue, 03 February 2009 07:40 Go to previous messageGo to next message
georgebush
Messages: 7
Registered: December 2008
Junior Member
Martin,

A SMALL BACKGROUND BEFORE I ANSWER YOUR QUESTIONS

Consider 2 forms

1)Admin form

This form has button. On the click of the button it sends an email out to a person. I want to create a link in this email so that on clicking the link, the user should be able to call another form(Feedback form).

i.e. The link (which is in the email) should call the .bat file
which contains the call for the feeback form(ifrun60 feedback.fmx userid/pwd@servicename request_no=10)

2)Feedback form

ANSWERS TO YOUR QUESTIONS

Where is the link?
The link is in the email

What does it look like?
?? hyperlink?

Is the email calling the form or the form calling the email?
The email should have a link to call the form.

MY QUESTION

HOW TO CREATE A LINK INSIDE THE EMAIL TO CALL THIS .BAT FILE?

Kindly let me know.

Thanks,


Re: passing a value at runtime [message #384463 is a reply to message #384341] Tue, 03 February 2009 23:47 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Calling a Microsoft '.bat' file from an email I consider to be a Microsoft problem, not a Forms problem.

From my very limited knowledge of Microsoft and calling batch files, I assume that the value for 'request_no' would have to be passed as a parameter to the batch file and this batch file would do the necessary substitution to put it into the parameter string.

Y ou need to look at a Microsoft forum for the answer.

David
Previous Topic: LOVS
Next Topic: use of Fingerprint device in Oracle Form 10g
Goto Forum:
  


Current Time: Tue Feb 18 13:30:15 CST 2025