parameters on select

pwatel · Post by **pwatel** » Wed 03 Jun 2009 07:55

hi everyone
if I have

q.sql.text := SELECT FROM atable WHERE MYKEY=:MYKEY
q.ParamByName('MYKEY').value := 'avalue'
q.open

it works well the first time
if I want to set a new value for the parameter and have the query
get a new record(s)

what is the best way
I know that q.close+q.open works but it is a bit primitive
is there a refresh or requery method or ??????you tell me
thanks
Philippe Watel

Plash · Post by **Plash** » Thu 04 Jun 2009 07:05

You should use the Close and Open methods.

pwatel · Post by **pwatel** » Thu 04 Jun 2009 08:28

It will work
primitive but it works (just kidding.....)
PW