parametrized views

[Nifrabar]

Hi!
On a form in a parametrized view I have
....
where table.nId = ?gnID

So I use a global as condition for the subset.
Can that also be done with a formproperty?

The disadvantage of using a global is that once there should be more forms instanciated they all will relay on that global. So Formproperty would more fit.
But.... I did not got that to work.

Any idea?

-Bart

 

[Olaf Doschke]

in the context of the sql running, THISFORM cannot be referenced, therefor it didn't work out.

Use a local variable. The parameter is used at query time only, so the var does not need to exist as long as the view exists, only each timy you USE it or you requery it.

So you could store the parameters in form properties, but then each time whn using or requerying the view would copy those properties to local vars.

Bye, Olaf.

 

[Nifrabar]

Thanks Olaf
Going to follow your advice.
KR
-Bart