Search:

Type: Posts; User: DanielS83; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    5
    Views
    586

    Re: Parameter in ODBC PowerQuery

    The solution is so much more easier:



    let
    Quelle = Odbc.Query("dsn=WWC400", "select * from bbu00 where BUFNR = '"&BUFNR&"'and BUBHKZ = '"&BUBHKZ&"' and BUPKTO ='"&BUPKTO&"'")
    in
    ...
  2. Replies
    5
    Views
    586

    Re: Parameter in ODBC PowerQuery

    Something is also not working with the code...just tried this out, but getting error message:

    DataSource.Error: ODBC: ERROR [42000] [IBM][System i Access ODBC-Treiber][DB2 für i5/OS]SQL0104 -...
  3. Replies
    5
    Views
    586

    Re: Parameter in ODBC PowerQuery

    Thx...but is this solution much more slowly than making it with an sql statement?

    Br
    Daniel
  4. Replies
    5
    Views
    586

    Parameter in ODBC PowerQuery

    Hi Everyone,


    I've tried to use a parameter from Excel cell to modify an ODBC Query from AS400 Database like this:


    let
    BUPKTO = Kunde,
    Quelle = Odbc.Query("dsn=AS400", "SELECT BBU00.BUFNR,...
Results 1 to 4 of 4