Re: Parameters

OneDeveloper wrote: > I have to use Sql Server 2000 DTS to manage an Informix 5 database on Unix > Sco 5 . > It's possibile trough ODBC (Intersolv) declare a parametric query like this: > > SELECT * FROM TABLE WHERE COL=?> > If it is possible what is the correct syntax? That looks like the correct syntax - why do you think it might not be? -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

> That looks like the correct syntax - why do you think it might not be? Because when I parse the query I receive no error but when I try to assign a value to the parameters Sql Server give me the message: - "Provider cannot derive parameter information and SetParameterInfo as not been called." I think that the odbc driver doesn't implement this type of query....

Only guessing but do you need to quote the place holder? Daniele wrote: > > > That looks like the correct syntax - why do you think it might not be? > > Because when I parse the query I receive no error but when I try to > assign a value to the parameters Sql Server give me the message: > > - "Provider cannot derive parameter information and SetParameterInfo > as not been called." > > I think that the odbc driver doesn't implement this type of query.... -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #