🚀 go-pugleaf

Judy and Frank Button wrote:

> 1) Anytime I try to edit the SQL from the inspector as I close the
> editor I get an error " variable mYearPaid not Defined".  I close anyway
> and the Active property resets to False from True and when I open the
> Params property the data type has changed from Numeric to Logical.

Try this: set the active to false first, then change the SQL to include 
the parameter. Go the params property and set the value. Then set the 
active property to true.

> 2) Once I have conquered this problem I am going to want to change the
> value of mYearPaid to be able to vary the results of the query.  I was
> going to use a PushButton on Click event.  Will that work??

Sure. In the onClick, change the value in the params array. Then 
requery(), something like:

  function someButton_onClick()
    form.L28CLASS1.params[ "mYearPaid" ] = form.entryfield1.value
    form.L28CLASS1.requery()

-- 
//Ken[0]@Borland
<Please follow-up to newsgroup; do not reply to email>