Forum Discussion
almagir
10 years agoRegular Visitor
How to enter a parameter into the sql statement
Hi,
I've this query with an sql statement:
= Odbc.Query("dsn=churrera", "sel top 10* from dwpryvp0.jnfs_territBO_vent_v_new where fx_anno=2016")
I would like to insert the year (2016) through a parameter.
I've created the parameter "year(2016)" but I don't know how to define it in the sql statement.
Thanks in advance
hi almagir,
try the following:
= Odbc.Query("dsn=churrera", "sel top 10* from dwpryvp0.jnfs_territBO_vent_v_new where fx_anno=" & year)
regards,
konrad
2 Replies
- radpirResolver II
hi almagir,
try the following:
= Odbc.Query("dsn=churrera", "sel top 10* from dwpryvp0.jnfs_territBO_vent_v_new where fx_anno=" & year)
regards,
konrad
- almagirRegular Visitor
Hi Konrad,
It has worked as you told me.
I've had to convert the number 2016 to text.
Thanks for your help.
Regards