|
|
Posted by Erland Sommarskog on 08/17/07 10:18
(teddysnips@hotmail.com) writes:
> You can filter this data by selecting a column, right-clicking and the
> context menu exposes a "Filter For: text box. Enter a value, and the
> grid/subform is filtered at once.
>
> The SQL trace captures something like
> "SELECT Column1, Column2 FROM MyTable WHERE Column2 = "This Value"
>
> This Search form also has a "Filter" button and some controls that
> correspond to the columns displayed in the grid. This allows the user
> to filter on more than one column. (For any Access people reading
> this, in the VB the SELECT string is built up, and a stored query or
> QueryDef is edited with the new SQL. Finally, the Data Source
> property of the subform is set to the QueryDef). However, if I mimic
> the filter from the context menu (the filter, you recall, that WORKED
> instantaneously), the application hangs and eventually times out.
>
> The SQL trace captures something like
> "SELECT Column1, Column2 FROM MyTable WHERE Column2 = "This Value"
>
> So, the two operations generate identical SQL, but one works exactly
> as expected while the other barfs.
>
> FINALLY, and this is where I think the ODBC that the other respondee
> here (sloan) alluded to is a red herring, is that if I copy this SQL
> to Query Analyzer and run it, it NEVER runs to completion. So there
> is no network, or other transport that might affect the result.
>
> My thinking currently, given that the system mysteriously righted
> itself yesterday afternoon, only to fall over again this morning, is
> that the instance of SQL Server may be corrupted.
>
> Thoughts?
Trying to diagnose a system on hearsay is about impossible.
But if the query does not complete in QA, maybe should investigate if there
is any blocking.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|