Data Connection to a SQL View - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Data Connection to a SQL View

Last post 03-03-2009 02:36 AM by Dremandred. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • 03-02-2009 06:03 AM

    Data Connection to a SQL View

    Reply Contact

    Hi all

     

    I have a view in a SQL database which is the result of a Join between to tables. I would like to connect to this view in InfoPath, however it seems that when I run the Data Connection wizard and connect to the database, InfoPath only allows me to connect to the databases tables.

    Am I missing something simple to be able to connect to and query a View?

     

    Many thanks for any help and suggestions.

  • 03-02-2009 08:59 PM In reply to

    Re: Data Connection to a SQL View

    Mark as Answer
    Reply Contact

    Hmmmm -- I just tried and all my views showed up in the list with my tables. You can always edit the SQL (in the data connection wizard, click the Edit SQL button) and change the 'from' statement to use your view.

    Hilary Stoupa

  • 03-03-2009 02:36 AM In reply to

    Re: Data Connection to a SQL View

    Mark as Answer
    Reply Contact

    Thanks, based on your reply I created a new test DB on my PC and I can see the view perfectly. I suspect that I was having SQL permissions issues on our test server.

    Many thanks.

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.