Infopath queries database twice... - InfoPath Dev Sign in | Join | Help in General 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 » General » Infopath queries database twice... Infopath queries database twice... Last post 12-19-2008 11:21 AM by Hilary Stoupa. 1 replies. Page 1 of 1 (2 items) Sort Posts: Oldest to newest Newest to oldest Previous Next 12-19-2008 06:54 AM Graeme Joined on 09-05-2008 Posts 82 Infopath queries database twice... Reply Contact Using SQL Profiler I noticed that the same query is sent twice to SQL Server - the first time a "where 1 = 0" clause is added. Obviously that won't return any rows, but any idea why it does this? 12-19-2008 11:21 AM In reply to Hilary Stoupa Joined on 06-20-2008 Posts 13,297 Re: Infopath queries database twice... Mark as Not AnswerMark as Answer... Reply Contact Often queries get sent twice because the first call is used to generate / validate the schema..... Hilary Stoupa Page 1 of 1 (2 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.
Using SQL Profiler I noticed that the same query is sent twice to SQL Server - the first time a "where 1 = 0" clause is added. Obviously that won't return any rows, but any idea why it does this?
Often queries get sent twice because the first call is used to generate / validate the schema.....