Filter on File Drop

[Richard I]

Hi,
On a form, I have a file drop on Department Name (Dep:Name)
Each record in the Department table has a ZoneNumber (Dep:Zone)

Each Employee has a zone Number (EMP:ZoneNumber)

I want the file drop to display only those Departments that have the same zone number as the employee's zone  last logged in

The filter doesnt like the = in the expression Im trying to set and besides, the Dep:Zone hasnt been called...?

How to please?

Many thanks
Richard
NT 11.07

[DonRidley]

Assuming Strings...
'Dep:Zone = ' & '''' & p_web.GSV('StoredEmployeeZone') & ''''

or maybe even...
'UPPER(CLIP(Dep:Zone)) = ' & '''' & UPPER(p_web.GSV('StoredEmployeeZone')) & ''''  !No need to clip the Session Value

Assuming Longs...
'Dep:Zone = ' & p_web.GSV('StoredEmployeeZone')

Where StoredEmployeeZone = Session value stored when user logs in.

There are better ways to construct the string filter but it works for me.

The NetTalk drop downs use Views.  Make sure Dep:Zone is in the View.

Don

[Richard I]

Many thanks Don, again !!
much obliged.
Works perfectly.
So simple but so far!

Cheers
Richard

[Bruce]

Hi Don,

Good answer - just one thought;

>> The NetTalk drop downs use Views.  Make sure Dep:Zone is in the View.

Fields used in _Filters_ do not need to be PROKECTED in the VIEW. While that's a fairly common Clarion myth it has no basis in fact.

cheers
Bruce

[DonRidley]

Hi Don,

Good answer - just one thought;

>> The NetTalk drop downs use Views.  Make sure Dep:Zone is in the View.

Fields used in _Filters_ do not need to be PROKECTED in the VIEW. While that's a fairly common Clarion myth it has no basis in fact.

cheers
Bruce

Thanks for the reminder Bruce!  Just keeping you on your toes!  LOL