Alpha Video Training
Results 1 to 3 of 3

Thread: Dyanmic Connection Strings and e.cn SQL::Connection object for the Grid

  1. #1
    Member
    Real Name
    John Azzara
    Join Date
    Aug 2011
    Posts
    40

    Default Dyanmic Connection Strings and e.cn SQL::Connection object for the Grid

    My application uses or will be using dynamic connection strings. I have number of grids in which the OnAfterSQLCommandExecute and OnBeforeSQLCommandExecute events are used. Currently, on these events we are using e.cn.execute to execute our SQL. My question is does e.cn resolve the proper connection when it is a dynamic connection that is set on an a5w. page or will it use the connection string in the project profile?

  2. #2
    Member
    Real Name
    Matt Bavis
    Join Date
    Mar 2008
    Posts
    45

    Default Re: Dyanmic Connection Strings and e.cn SQL::Connection object for the Grid

    I also need to use dynamic connection strings and would be curious to know the answer to this question.

    Thanks,
    Matt

  3. #3
    Member
    Real Name
    John Azzara
    Join Date
    Aug 2011
    Posts
    40

    Default Re: Dyanmic Connection Strings and e.cn SQL::Connection object for the Grid

    Hi Matt,

    To answer the original question I asked at the start of the thread, YES if you use the connection property of any e object it will properly resolve to the dynamic connection string session variable set on an a5w page. In other words, if you you are using OnAfterSQLCommandExecute and OnBeforeSQLCommandExecute events in your components all you need to use is e.cn.execute. We've tested it and it works great. Take care.

Similar Threads

  1. Variables in Connection Strings
    By Bob Whitaker in forum Alpha Five Version 11 - Desktop Applications
    Replies: 2
    Last Post: 01-10-2013, 07:41 AM
  2. xBasic SQL Query connection object ResultsSet 100 record limit, other options?
    By LukeS in forum Application Server Version 11 - Web/Browser Applications
    Replies: 2
    Last Post: 11-12-2012, 06:28 PM
  3. publish grid w/ different connection string from Project Named AlphaDAO connection
    By KYBiggs in forum Application Server Version 10 - Web/Browser Applications
    Replies: 4
    Last Post: 01-22-2012, 12:40 PM
  4. Connection Strings
    By raven in forum Application Server Version 10 - Web/Browser Applications
    Replies: 2
    Last Post: 06-08-2010, 04:45 PM
  5. Connection Strings
    By monghe in forum Alpha Five Version 9 - Desktop Applications
    Replies: 2
    Last Post: 08-04-2009, 08:44 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •