NetWebForm - filter on Drop

[Johan van Zyl]

First a Country is selected via a Drop from Country Table
Then I would like to select a  Province from Province table filtered on CountrySysID
neither of these filters work
‘pro:countrysysid = ' & p_web.GSV(‘cou:countrysysid')
 'pro:countrysysid = <39>' & p_web.GSV('cou:countrysysid') & '<39>'

Drop Filter web33.app does not seem to apply here.

[Bruce]

a) Is cou:countrysysid a string or a number?

b) is Province added as a field in the Reset Field List of the Country field?

c) if you tick on "send order/filter to debugview" - what filter appears _after_ you select the country?

cheers
Bruce

[Johan van Zyl]

RESOLVED!
The Form is for people table

 filter must be:
 'pro:countrysysid = <39>' & p_web.GSV('peo:countrysysid') & '<39>'
and had to reset!


sysid's always INTEGER

CREATE TABLE geo.countries(
   countrysysid serial PRIMARY KEY,
  countrycode varchar(10) UNIQUE,
  countrycodeshort  varchar(10) UNIQUE,
   countrydescr citext UNIQUE,
  dailingcode citext,
...
CREATE TABLE geo.provinces(
   provincesysid serial PRIMARY KEY,
  countrysysid integer REFERENCES countries ON DELETE RESTRICT,
  provincecode citext UNIQUE,
   provincedescr citext,
   capitalcity citext,

Click on Drop for Provinces and select South Africa - when I click on Provinces only South African Provinces must be selectable.


I cannot find send order/filter to debugview under LookUp Settings of the Drop,
...

[attachment deleted by admin]