7/5/2025 11:32:05 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss the use of the SalesLogix Web Platform, Client and Customer Portals, and the Application Architect (For version 7.2 and higher only). View the code of conduct for posting guidelines.
|
|
|
|
Not able to browse customise Main View when I click on Navbutton
Posted: 03 Jun 09 2:37 AM
|
Dear all
Need your help on Creating Main view for custom table. The following steps were how I created main view;
1. Create custom table by using New entity wizard
2. Create details form by using New form wizard
3. Create Main view by using New Page wizard. Type is Main View
4. Create Nav button for for customize page.
5. Creat context menu for Customizae page
6. The argument used for Lookup is "store.aspx?modeid=list
7 The argument used for create lookup is "javascript:groupManager.Creategroup('STORE');
8 Build and I deployed
I hit the error when I click on the nav button . The error is as follow;
"
Failed to parse SQL.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Failed to parse SQL.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[OleDbException (0x80040e14): Failed to parse SQL.]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +267
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +192
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +48
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +106
System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +111
System.Data.OleDb.OleDbCommand.ExecuteReader() +6
Sage.SalesLogix.Client.GroupBuilder.GroupInfo.GetGroupDataReader(Boolean DoPaging, Int32 FirstRow, Int32 PageSize, String SortField, Boolean JustIDs) +229
[GroupInfoException: GetGroupDataReader Failed: ]
Sage.SalesLogix.Client.GroupBuilder.GroupInfo.GetGroupDataReader(Boolean DoPaging, Int32 FirstRow, Int32 PageSize, String SortField, Boolean JustIDs) +278
Sage.SalesLogix.Client.GroupBuilder.GroupInfo.GetGroupIDs(Boolean doPaging, Int32 firstRow, Int32 PageSize, String sortExp) +72
Sage.SalesLogix.Client.GroupBuilder.CachedGroup.SetupIDList() +125
Sage.SalesLogix.Client.GroupBuilder.ClientContextRepresentation.From(GroupContext context) +310
Sage.SalesLogix.Client.GroupBuilder.ClientGroupContextService.CreateClientContext() +45
Sage.SalesLogix.Client.GroupBuilder.ClientGroupContextService.OnPreRender(EventArgs e) +74
System.Web.UI.Control.PreRenderRecursiveInternal() +77
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360
"
|
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|