How To Improve SQL Server Query Performance by Using Indexes
/documentation/pages/HowTo/Databases/Improve SQL Server Query Performance Using Indexes.xml
Performance of queries against SQL Server can be affected by string arguments due to an issue with the SQL Server optimizer.
Web Application Server Functions
/documentation/pages/Ref/Api/Functions/Web/Web Application/Server Functions/index.xml
Alpha Anywhere provides the following functions for controlling the Web Application Server.
Server-side Properties
/documentation/pages/Guides/Mobile and Web Components/UX/Controls/Props/Data/List Properties/listprops/Fields/Server-side/index.xml
Specify how the field data is transformed on the server before being sent to the client's browser or mobile device.
Application Server Help Pages
/documentation/pages/Index/Application Server Help Pages.xml
Page links relating to the Application Server.
Locating Logs for the Alpha Anywhere Application Server for IIS
/documentation/pages/Troubleshooting/Web Server/IIS Log Files.xml
Log files are useful for troubleshooting issues in web applications. The Alpha Anywhere Application Server for IIS writes events to the Xbasic Error log and Trace logs when abnormal conditions are encountered. The Application Server for IIS also writes to the Windows Event Logs. Failed Request Tracing can be used, as well, to track down failed requests.
Xbasic Server-side API Library
Xbasic functions, classes, and objects available for both server-side scripts and desktop applications.
Server-side Events
/documentation/pages/Guides/Mobile and Web Components/Grid/Code/Server-side Events/index.xml
Pages relating to Server-side Events in the Grid Builder.
/documentation/pages/Ref/Api/Objects/System/OLE/OLE.CLASSES Method.xml
Get a list of OLE Automation Classes
Server-side Group Breaks
/documentation/pages/Guides/Mobile and Web Components/UX/Controls/Props/Data/List Properties/listprops/Data Source/Server-side Group Breaks/index.xml
Server-side Group Breaks can be used with different data source types. Group breaks take the form of headers over blocks of data that share something in common. These should not to be confused with titles. Whereas a title is inserted above a block of data, group breaks draw their definition from the data itself. Alpha Anywhere contains a number of properties that help in determining how the group break should be formed from existing data, whether or not it should be used to sort data, and means of changing group break headers. These properties are listed here.
Server-side Events
/documentation/pages/Guides/Mobile and Web Components/UX/Controls/Props/Data/List Properties/listprops/Detail View/Server-side Events/index.xml
The List control Detail View's server-side events can be used to add additional logic for during synchronization and validation.