Re: ///// HELP HELP. Enter - Query mode \\\\\

You might achieve your purpose with a couple of triggers.

A WHEN-NEW-FORM-INSTANCE trigger:

DEFAULT_VALUE('','global.variablename'); IF :global.variablename is not null THEN

    EXECUTE_QUERY;
END IF; A PRE-QUERY trigger:

IF :fieldname is null THEN

    IF :global.variablename is not null THEN

        :fieldname := :global.variablename;     END IF;
END IF; You also might want to set :global.variablename := null in your KEY-ENTQRY or KEYEXEQRY triggers.   

Gerard H. Pille <ghp_at_santens.be> wrote in article <01bcce73$3a576c20$7b1340c0_at_pcghp.santens.be>...
> You could refer to that variable in the where-clause of the block, and
> execute_query automatically when you enter the form.
> --
> ------------
> Kind reGards
> \ / |
> X |
> / \ x
> Gerard
>
> Arn Nguyen <s337202_at_student.uq.edu.au> schreef in artikel
> <3432501C.9E163F0A_at_student.uq.edu.au>...
> > HI,
> >
> > Is it possible to be in Enter-Query and then have that field assign to
 a
> > particluar value and then Eexecute it.
> >
> > What I am trying to do is when you first enter in a particular form
> > called from another form, I want it automatically execute a query based
> > on the global variable that I brought in. But I can't seem to achieve
> > it.
> >
> > Please email
> >
> > s337202_at_student.uq.edu.au
> >
> > -Arn Nguyen
> >
> >
>
  Received on Fri Oct 03 1997 - 00:00:00 CDT