Creating SQL-Lesson Learned - InfoPath Dev Sign in | Join | Help in Data Connections InfoPath (Entire Site) InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads InfoPath Dev » InfoPath » Data Connections » Creating SQL-Lesson Learned Creating SQL-Lesson Learned Last post 08-29-2006 06:23 PM by Matt Faus. 2 replies. Page 1 of 1 (3 items) Sort Posts: Oldest to newest Newest to oldest Previous Next 07-17-2006 01:41 PM dlgross Joined on 03-23-2006 USA Posts 271 Creating SQL-Lesson Learned Reply Contact I just learned that I can use SQL Server Query Analyzer to create/modify SQL statements and paste them into a Secondary Data Connection thereby bypassing the ADO Shape object syntax. This seams to be providing better performance and a much better design environment for the SQL statements. It also provides a flat data structure that is easier to navigate if you want to create Rules for populating other fields on a form.HTHDean DeanCharlotte, NC 07-17-2006 07:44 PM In reply to Kalyan Gaddam Joined on 07-18-2005 India Posts 362 Re: Creating SQL-Lesson Learned Mark as Not AnswerMark as Answer... Reply Contact Hello,Thanks for sharing the information. Kalyan G ReddyInfopath MVP 2007 and 2008 08-29-2006 06:23 PM In reply to Matt Faus Joined on 08-18-2006 Dallas, Texas Posts 1,558 Re: Creating SQL-Lesson Learned Mark as Not AnswerMark as Answer... Reply Contact Hey Dean!Thanks for this info, I will have to try this out! Matt Faus / Microsoft InfoPath MVPQdabra® Software / Streamline data gathering to turn process into knowledge Page 1 of 1 (3 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.