passing variable between stacks

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
mimsma
Posts: 4
Joined: Mon Jun 15, 2009 11:04 pm

passing variable between stacks

Post by mimsma » Mon Jun 22, 2009 8:59 pm

I have been trying to pass variables. Some pas and some don't. I generate a SQL query and them doubleclik on that line item from the table. It opens sanother stack which has a database form and fills in the information from the query. All fields are not populating.

global myUsr
global myPass
global TableResult
global tadult
global tlevel
global tlastname
global tfirstname
global tmi
global ttitle
global taddress
global myCity
global tstate
global myPostalcode
global thome_phone
global temail_address
global tbishop
global tdiocese
global tgender,
global tordained

the new form called get's this.

on preopenstack
put the storedHeight of me into tHt
put the top of me into tTop
set the height of me to tHt
set the top of me to tTop
put tfirstname into field firstname
put tlastname into field lastname
put taddress into field address_1
put myCity into field city
put tstate into field state
put myPostalcode into field postalcode
put thomephone into field phone
put temail into field email
put tbishop into field StateBishop
put tpastor into field Pastor
put tdiocese into field diocese
put tlocalband into field localband
pass preOpenStack
end preopenstackt

any solutions

mimsma
Posts: 4
Joined: Mon Jun 15, 2009 11:04 pm

passing variable between stacks

Post by mimsma » Mon Jun 22, 2009 9:03 pm

this is also part of the second stact that is called:

global myUsr
global myPass
global TableResult
global tadult
global tlevel
global tlastname
global tfirstname
global tmi
global ttitle
global taddress
global myCity
global tstate
global myPostalcode
global thome_phone
global temail_address
global tbishop
global tdiocese
global tgender,
global tordained

Klaus
Posts: 14206
Joined: Sat Apr 08, 2006 8:41 am
Contact:

Post by Klaus » Tue Jun 23, 2009 8:30 am

Hi mimsma,

you need to "call" the variables before you use them in the same handler!

Like this:

Code: Select all

on preopenstack 
   global myUsr 
    global myPass 
    global TableResult 
    global tadult 
    global tlevel 
    global tlastname 
    global tfirstname 
    ...
    put the storedHeight of me into tHt 
    put the top of me into tTop 
    set the height of me to tHt 
    set the top of me to tTop 
    put tfirstname into field firstname 
    put tlastname into field lastname 
   ...
   pass preOpenStack 
end preopenstackt
Best

Klaus

Post Reply