DevForce Community Forum : SqlWhereClause Change at runtime http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2009 : SqlWhereClause Change at runtime Sat, 11 Apr 2026 14:22:03 -700 Thu, 28 Jan 2010 09:55:52 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1625 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ SqlWhereClause Change at runtime : The simplest way to do this is... http://www.ideablade.com/forum/forum_posts.asp?TID=1625&PID=6148#6148 Author: davidklitzke
Subject: 1625
Posted: 28-Jan-2010 at 9:55am

The simplest way to do this is with a PassthruRdbQuery.  There is an Intermediate Tutorial named "Pass-Through Queries".
 
There is a more complicated way to do this which requires writing some code which executes server-side.  There is an Advanced Tutorial named "Remote Service Methods".
]]> Thu, 28 Jan 2010 09:55:52 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1625&PID=6148#6148 SqlWhereClause Change at runtime : This question belongs in the "DevForce... http://www.ideablade.com/forum/forum_posts.asp?TID=1625&PID=6144#6144 Author: smi-mark
Subject: 1625
Posted: 28-Jan-2010 at 8:36am

This question belongs in the "DevForce Classic Edition Topics" forum, not the Silverlight forum.

But to answer your question, yes, you can.

In your business object you can add this:

VB:

    Private _newWhereClause As String = "WHERE CLAUSE HERE"

    Public Overrides ReadOnly Property SqlWhereClause() As String
        Get
            Return _newWhereClause
        End Get
    End Property

C#:

private string newWhereClause = "WHERE CLAUSE HERE";

public override string SqlWhereClause()
{
         get
         {
              return newWhereClause; 
         }
}
]]> Thu, 28 Jan 2010 08:36:42 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1625&PID=6144#6144 SqlWhereClause Change at runtime : i am using DevForce Classic, can... http://www.ideablade.com/forum/forum_posts.asp?TID=1625&PID=6143#6143 Author: vinothvdp
Subject: 1625
Posted: 28-Jan-2010 at 3:48am

i am using DevForce Classic, can i do here.if can then please give me some sample.]]> Thu, 28 Jan 2010 03:48:32 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1625&PID=6143#6143 SqlWhereClause Change at runtime : For DevForce Silverlight, you... http://www.ideablade.com/forum/forum_posts.asp?TID=1625&PID=6128#6128 Author: davidklitzke
Subject: 1625
Posted: 25-Jan-2010 at 9:36am

For DevForce Silverlight, you would not use a SqlWhere clause in a command that you would send to the database.  You would use Linq and send the query to a DevForce EntityManager.]]> Mon, 25 Jan 2010 09:36:40 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1625&PID=6128#6128 SqlWhereClause Change at runtime : Greets, i want to change the... http://www.ideablade.com/forum/forum_posts.asp?TID=1625&PID=6112#6112 Author: vinothvdp
Subject: 1625
Posted: 23-Jan-2010 at 4:29am

Greets,

i want to change the SqlWhereClause at run time. is this possible please help me out.

Thank you]]> Sat, 23 Jan 2010 04:29:25 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1625&PID=6112#6112