Forum Discussion

almagir's avatar
almagir
Regular Visitor
10 years ago
Solved

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 ...
Need Help
  • radpir's avatar
    radpir
    10 years ago

    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

radpir's avatar
radpir
Resolver II
10 years ago

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

  • almagir's avatar
    almagir
    Regular Visitor
    10 years ago

    Hi Konrad,

     

    It has worked as you told me.

     

    I've had to convert the number 2016 to text.

     

    Thanks for your help.

     

    Regards