Hi there

I'm having difficulty getting a resultset back for what would be a "join" query in SQL using relations and predicates.

I can write the SQL into SQL Server Query Analyser and get the result I want but when I attempt to do the same thing via a relationcollection and Predicate I get no result - so I know I am not quite doing something right.

I'm wondering if it is possible (because we are using self-servicing not adapter) to view the SQL query that is being generated?

regards

Randall

You can step into the DAO class in the debugger and step OVER the method call which creates the IRetrievalQuery object. When you step OVER that line, you can examine the query in the locals window in the debugger, click open the selectQuery object and browse to the _command object which contains a commandText property.

If you're using VB.NET, this is not visible to you because the VB.NET IDE team thought it wouldn't be interesting, so you then have to do in the intermediate window:

?(CType(selectQuery, RetrievalQuery).ToString())

Thanks! I'll give it a go...