Home » Developer & Programmer » Forms » passing data through forms
passing data through forms [message #195709] Sun, 01 October 2006 11:25 Go to next message
dwforrest
Messages: 3
Registered: October 2006
Junior Member
Hi all,

I have two forms, one being 'searchtoy.fmb' and the other 'bookings.fmb'. I have built a query in 'searchtoy' what has the following:

SELECT T_ID
INTO ????????????
FROM TOY
WHERE TOY.T_ID = :TOYSEARCH.CHOICE;

EXCEPTION
WHEN NO_DATA_FOUND THEN
alert_button := SHOW_ALERT('BOOKINGERROR');

OPEN_FORM(:GLOBAL.project_path || 'BOOKINGS');

Where i have the ??????? in the above code, i want to place in code that allows the query to be returned to a specific block_name.item_name (newbooking.T_ID) in the form BOOKINGS.

I am unable to achieve this and was hjoping someone would be able to help me out.

Thanks, Dave
Re: passing data through forms [message #195725 is a reply to message #195709] Sun, 01 October 2006 21:13 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

Use global or pass parameter to BOOKINGS form then use it for your query.
Re: passing data through forms [message #195738 is a reply to message #195709] Mon, 02 October 2006 01:40 Go to previous message
h_jitendras
Messages: 36
Registered: October 2006
Member
You can do one of the following:-
1.Use global variables.
2.Create a parameter list in the calling form as well as in the called form to collect the parameters being passed from the calling form to the called form.

Either of this would help.

bye.
Previous Topic: SCROLL BAR
Next Topic: problem in NEXT ITEM
Goto Forum:
  


Current Time: Fri Sep 20 11:43:00 CDT 2024