|
Hi I’m trying to build a Windows Form application that
needs to alter the definition of a View, depending on user input/selection. Essentially,
the user is selecting a property of known coordinates (‘x’,’y’)
and setting a ‘buffer’ distance . I then want to retrieve the records
which represent the map features within the specified distance of the property.
The WHERE clause of my view is: st_dwithin(mytable.geom,
st_setsrid(st_point(x, y), 27700), buffer); I’m thinking this could be achieved either by making
x, y and buffer parameters or, I simply ALTER the View statement with
literal values. Whichever, I need to do this from a command line attached to a
windows form event, e.g. button_click. I cannot work out how to do this. Can anyone point me in the
right direction. I’ve looked at psql.exe, but can’t work out if
this holds the answer. Thanks Oisin |
