🚀 go-pugleaf

Craig Cohernour wrote:
> don't know how to reference the memory variable in the sql statement or
> in the visual sql tools.

You have to convert the variables into parameters in the "parameterized" 
SELECT statement. Basic steps are:

1. Assign a SQL SELECT statement that contains parameter names preceded 
by colons to the sql property of the Query object. For example (here the 
field name and parameter name just happen to be the same; a common 
practice, but not required):

  select * from WHATEVER where STATUS > :status

2. That automatically creates elements in the Query object's params 
array. You might want to assign default values for these parameters, 
which you can do through the tool in the Inspector for the query's params 
property.

3. Use the query's canOpen event to copy the variables that already exist 
into the params array. Be sure to return true from the canOpen event 
handler. Something like:

  function query_canOpen
    this.params[ "status" ] = st_stat // Copy variable
    return true

-- 
//Ken@Inprise
<Please follow-up to newsgroup; do not reply to email>