2. ASPRunner.NET General questions
  3. [SOLVED]  Custom View SQL Editor
This topic is locked
[SOLVED]

 Custom View SQL Editor

 		11/3/2010 08:25:18
ASPRunner.NET General questions
Q
 QueenKirsty author

I am trying to edit custom views. The help files state that "SQL query can be modified later on SQL query tab in ASPRunner.NET", however I do not seem to be able to find the tab.

Please can you tell me where to find this page?
Sergey Kornilov admin 11/4/2010

There is no SQL Editor in ASPRunner.NET. This is a restriction of Data Access Layer provider (Subsonic) that doesn't support custom SQL queries.
If you need to use custom SQL queries you can create view right in your database and use it as a datasource in ASPRunner.NET.
K
 		Khronos 12/9/2010

In cases I have to use views instead of tables, when i try to view the certain row by clicking the "View" button I get this error



Object reference not set to an instance of an object.

Stack trace: at SubSonic.ActiveRecord`1.fetchByID(Object keyValue)

at SubSonic.ActiveRecord`1.FetchByID(String keyValue)

at CVIEW_Invoice_List_PerFile_View.BuildForm()

at CVIEW_Invoice_List_PerFile_View.Page_Load(Object sender, EventArgs e)

at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)

at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)

at System.Web.UI.Control.OnLoad(EventArgs e)

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


What's wrong and how can i fix it?
Thanks
Sergey Kornilov admin 12/10/2010

It's hard to tell what might be wrong without seeing your files and database.
I would suggest to post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.