Forum Discussion

simonb's avatar
simonb
Regular Visitor
7 years ago

Using Paramters to define ODBC connection

Hi,   Wondering if there's a way to use a parameter to define the ODBC Data source. I want to connect via CData's ODBC driver for Xero. This provides access to multiple tables via SQL statements. I...
Need Help
parry2k's avatar
parry2k
Super User
7 years ago

simonb I believe it would be like below, assuming your parameter name is Connection

 

 

= Odbc.Query("dsn=" & [Connection] & ", "Select * from TrialBalance where date=[PeriodEnding]")
simonb's avatar
simonb
Regular Visitor
7 years ago

parry2k thanks,  that returns a Token Comma Expected error highlighting Select

 

 I've tried a few iterations but can't find one that works...any thoughts?

 

Thanks,

Simon

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    simonb sorry I had typo in my message, try this

     

    = Odbc.Query("dsn=" & [Connection] & ", Select * from TrialBalance where date=[PeriodEnding]")
    • simonb's avatar
      simonb
      Regular Visitor
      7 years ago

      parry2k 

       

      That changes the error to:

       

      Expression.Error: There is an unknown identifier. Did you use the [field] shorthand for a _[field] outside of an 'each' expression?

       

      Sorry!

      • klinejordan's avatar
        klinejordan
        Advocate II
        7 years ago

        I think this will work:

        = Odbc.Query("dsn=" & Connection & "", Select * from TrialBalance where date=[PeriodEnding]")