Re: Question about pick-lists in Forms*3.0

Kamran Derakhshan (kamrand_at_saturn.bwc.org) wrote:

> Can anyone suggest a remedy for the following:  

> Now you suddenly realise that you want to have a where clause added
> to your criterion so you change the "List of Values SQL Text" of
> the country field to: select country_name into :A.country from
> country_table where GNP > 2000
 

> Now the partially entered country name will no longer be completed
> automatically - instead a list of countries will pop-up to select from.
 

> So it seems that the where clause overrides the RESTRICT parameter.

select country_name
into :A.country
from country_table
where GNP > 2000
  and country_name like :A.country||'%'

should do the trick (not tested it tho')

--
  _________________________   ______________________________________
 /  Tommy Wareing          \ /  And I dream about movies            \
|  p0070621_at_brookes.ac.uk   X   They won't make of me when I'm dead  |
 \  0865-483389            / \      - Jon Bon Jovi, Keep the Faith  /
  ~~~~~~~~~~~~~~~~~~~~~~~~~   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~