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 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

  • 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

      Hi Konrad,

       

      It has worked as you told me.

       

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

       

      Thanks for your help.

       

      Regards