Re: TADOQuery and assign null value to the parameter

TADOQuery does not support the Clear method ... it can be used only when we
use data access components ...
any other ideas?

Ï "Brian Hollister" <bhollisterATfuturaintlDOTcom> Ýãñáøå óôï ìÞíõìá
news:4422f8fd$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Use the Clear method of TParam like so;

MhtrvoPagivn.repYlikaYpallhloi.Parameters[0].Clear;


hth,

brian

--
Got a big event coming up? Let us
help coordinate your event. For more
visit www.kissemgoodbye.com
"vverdenga" <vverdenga@xxxxxxxxxxxxxx> wrote in message
news:4422e87f@xxxxxxxxxxxxxxxxxxxxxxxxx
hi i have the following query:
select yliko.SERIAL_NUMBER,
yliko.PERIGRAFH,yliko.CODE_YPALLHLOY,yliko.CODE_KATASTASHS,
YPALLHLOI.NAME,
KATASTASH_YLIKOY.PERIGRAFH, ypallhloi.code
from yliko, ypallhloi, katastash_ylikoy
where (yliko.CODE_YPALLHLOY = ypallhloi.code)
and (yliko.CODE_KATASTASHS = KATASTASH_YLIKOY.code)
and (YPALLHLOI.code= :codeypal or :codeypal is null)
order by ypallhloi.name
the only thing i want to do is to assing values to the parameter using
the
folling code:
if ComboYpallhlos.KeyValue<>null then

MhtrvoPagivn.repYlikaYpallhloi.Parameters[0].Value:=FrmYlika_ypallhlo.ComboY
pallhlos.KeyValue
else
MhtrvoPagivn.repYlikaYpallhloi.Parameters[0].Value:=null;
my problem is that when my parameter don't have value i get no result...
so
i am asking how can i clear my parameter

when i delete the parameter from the sql i get the right results
select yliko.SERIAL_NUMBER,
yliko.PERIGRAFH,yliko.CODE_YPALLHLOY,yliko.CODE_KATASTASHS,
YPALLHLOI.NAME,
KATASTASH_YLIKOY.PERIGRAFH, ypallhloi.code
from yliko, ypallhloi, katastash_ylikoy
where (yliko.CODE_YPALLHLOY = ypallhloi.code)
and (yliko.CODE_KATASTASHS = KATASTASH_YLIKOY.code)
order by ypallhloi.name

thank's in advance






.

Relevant Pages