Modifying SyteLine ERP

1 infor ERP SyteLineModifying infor ERP SyteLineCopyright 2010 InforAll rights reserved. The word and design marks set forth herein are trademarks and/or registered trademarks of infor and/or its affiliates and subsidiaries. All rights reserved. All other trademarks listed herein are the property of their respective NoticesThe material contained in this publication (including any supplementary information) constitutes and contains confidential and proprietary information of infor . By gaining access to the attached, you acknowledge and agree that the material (including any modi-fication, translation or adaptation of the material) and all copyright, trade secrets and all other right, title and interest therein, are the sole property of infor and that you shall not gain right, title or interest in the material (including any modification, translation or adaptation of the material)

2 By virtue of your review thereof other than the non-exclusive right to use the material solely in connection with and the furtherance of your license and use of software made available to your company from infor pursuant to a separate agreement ("Purpose").In addition, by accessing the enclosed material, you acknowledge and agree that you are required to maintain such material in strict confidence and that your use of such material is limited to the Purpose described infor has taken due care to ensure that the material included in this publication is accurate and complete, infor cannot warrant that the information contained in this publication is complete, does not contain typographical or other errors, or will meet your specific requirements.

3 As such, infor does not assume and hereby disclaims all liability, consequential or otherwise, for any loss or damage to any person or entity which is caused by or relates to errors or omissions in this publication (including any supplementary information), whether such errors or omissions result from negligence, accident or any other AcknowledgementsAll other company, product, trade or service names referenced may be registered trademarks or trademarks of their respective InformationRelease: infor ERP SyteLine Date: December 9, 2010 Modifying infor ERP SyteLine Copyright 2010 infor Table of Contents About This Guide.

4 VFor More Information ..vSystem Requirements and Prerequisite Knowledge .. viContacting infor Support .. viToolset Overview .. 1-1 Summary of Tools .. 1-2 Opening Development Tools .. 1-3 Accessing Development Tools Help .. 1-3 Setup and Configuration .. 1-4 Configuration Manager .. 1-4 Service Configuration Manager .. 1-6 Database Tier ..1-7 Application Schema Forms .. 1-7 User-Extended Tables Forms .. 1-7 Middle (Objects) Tier .. 1-8 IDO Editing Forms .. 1-8 IDO Runtime Development Server .. 1-9 Presentation Tier.

5 1-10 WinStudio ..1-10 FormControl.. 1-10 Application Event System .. 1-11 Event System Forms .. 1-11 Application Upgrade and Maintenance .. 1-12 FormSync .. 1-12 App Metadata Sync .. 1-12 App Metadata Transport .. 1-13 Diagnostics ..1-14 Replication Tool.. 1-14 Log Monitor ..1-14 IDO Runtime Development Server .. 1-14 WinStudio ..1-14 Architectural Guidelines for Customers Modifying SyteLine .. 2-1 Prerequisites and Assumptions .. 2-2 Table of ContentsiiModifying infor ERP SyteLine Copyright 2010 infor Terminology.

6 2-3 Customizations ..2-4 Modifications .. 2-6Do Not Use SQL 2008 Merge Function.. 2-6 Build Installations as Additive SQL Scripts .. 2-6 General Guidelines .. 2-7UI Forms..2-7 Database Transact SQL Code (Stored Procedures, Triggers, Functions, Constraints) 2-8 Application Database Schema Changes (Table Structure) .. 2-8 Reports .. 2-9 External Touch Points .. 3-1 Overview .. 3-2 External Touch Point Code .. 3-3 Non-report Stored Procedures That Output an @Infobar Parameter .. 3-3 Non-report Stored Procedures That Do Not Output an @Infobar Parameter.

7 3-4 Report Stored Procedures.. 3-5 Using External Touch Points .. 3-7 Version Upgrades and Service Packs .. 3-8 Dynamic IDOs.. 4-1 Overview .. 4-2 Stored Procedure Calls .. 4-3 Collection Sources..4-5 Performance Issues.. 5-1 Locking and Blocking.. 5-2 Read Locks ..5-2 Transaction Size .. 5-4 Deadlocks .. 5-7 Cursors .. 5-8 Avoid Cursors ..5-8 Examples..5-9 Using Cursors .. 5-11 Triggers .. 5-13 Dynamic SQL .. 5-13 Temporary Tables and Table Variables.. 5-14 Miscellaneous Coding Tips .. 5-15 Procedures for Recompiling.

8 5-16 Table of ContentsiiiModifying infor ERP SyteLine Copyright 2010 infor Data Types ..5-17 Diagnosing Performance Problems .. 5-18 Viewing SQL Commands Initiated by the Framework .. 5-18 Timing Tests in SQL Server Management Studio .. 5-18 INSTEAD OF INSERT and AFTER UPDATE Triggers .. 6-1 Overview .. 6-2 INSTEAD OF INSERT Triggers.. 6-2 AFTER UPDATE Triggers .. 6-2 Maintenance Form.. 6-3 Maintenance Tasks .. 6-4 Creating Custom Application Messages .. 7-1 How the Toolset Generates Application Messages .. 7-2 Using GetErrorMessageSp to Build the Output Message.

9 7-2 Using Stored Procedures to Set Up Custom Application Messages .. 7-4 Message Numbers .. 7-7 Message Type .. 7-8 Object Type ..7-9 Licensing .. 8-1 Overview .. 8-2 Licensing New and Copied Forms.. 8-3 Multi-Site .. 8-4 Copy License Information .. 8-4 Licensing New and Copied IDOs.. 8-4 IsModuleLicensed Method.. 8-5 Sample Script ..8-5 Sample Event Handler.. 8-6 APIs for Strong Data Types .. 9-1 APIs for the Graph Component .. 10-1 APIs for the Tree Component .. 11-1 Sample Scripts with APIs for Strong Types.

10 A-1 Suggestions for Development Environment Configuration .. B-1 Maintain Separate Read-Only SyteLine Environments ..B-2 Use SourceSafe with IDO Metadata ..B-2 Table of ContentsivModifying infor ERP SyteLine Copyright 2010 infor Use SourceSafe for Application Database Scripts ..B-2 Numeric Constants Used in the Forms Database.. C-1 Scripting UET Definitions .. D-1 Extracting UET Definitions from the Source Environment ..D-2 Applying the Scripts in the Target Environment..D-3 Testing the Changes ..D-3 The ExportUETC lassSp Stored Procedure.