Q&A and Sesame allow programming code in retrieve spec when placed within { }.  Since @GlobalValue retain it's value, I thought, it will be very useful. But I have little success with it.

Let me explain what I am trying to do. Let us say, I am adding a record and I would like to lookup some pertinet info about this client from other database after retrieving the record of the same client.  I have entered the key value such as CustIdNumber,  I will have a button (on element entry) which will assign CustIdNumber to GlobalValue variable...

Globalvalue ("ClientId", CustIdNumber)
Writeln (@globalvalue ("ClientId"))

This confirms that @globalvalue ("ClientId") has been assigned proper value.  works fine so far. I did not go further with programming without confirming whether it works in Retrieve spec or not.

when I go to retrieve spec and use

{@globalvalue ("ClientId")}
or
=  {@globalvalue ("ClientId")}
or
{CustomerIdNumber = @globalvalue ("ClientId")}

nothing seems to work.  So I deduct that @globalValue() does not work in retrieve spec.   Globalvalue variable is the one which does not lose its value even when you close the program.  Why it is not available for retrieve spec? or am I wrong?

Quote:


I'll see what I can do for you.