{"product_id":"system-building-with-apl-win-9780470030202","title":"System Building with APL  WIN","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003eSoftware modernisation or re-engineering as a concept lacks universal clarity. \u003ci\u003eSystem Building with APL + Win\u003c\/i\u003e seeks to clarify this problem by identifying the solution to the long term survival of the APL application as the elimination of APL specific considerations in the choice of a development tool. The author shows how to deploy mainstream industry standard system components within an APL + Win development environment, enabling the APL application to be just like any application on the Windows platform.  \u003cul\u003e \u003cli\u003eDemonstrates the power and agility of APL + Win in today's approach to system building\u003c\/li\u003e \u003cli\u003eFeatures a code intensive' approach, which overcomes the lack of APL+Win specific documentation of system components\u003c\/li\u003e \u003cli\u003eIllustrates the potential for multi-language system building from an APL+Win environment\u003c\/li\u003e \u003cli\u003eExplains how increasing the collaborative nature of APL will enable it to become an even more valuable tool for application development\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003cb\u003eEditorial Foreword\u003c\/b\u003e.  \u003c\/p\u003e\u003cp\u003e\u003cb\u003eAcknowledgements\u003c\/b\u003e.\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePreface\u003c\/b\u003e.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1 - System Building Overview\u003c\/b\u003e.\u003c\/p\u003e \u003cp\u003e1.1 Why APL?\u003c\/p\u003e \u003cp\u003e1.2 Which APL?\u003c\/p\u003e \u003cp\u003e1.3 The n-tier model.\u003c\/p\u003e \u003cp\u003e1.4 Prevailing design architecture.\u003c\/p\u003e \u003cp\u003e1.5 APL interface to components.\u003c\/p\u003e \u003cp\u003e1.6 Structured Query Language (SQL).\u003c\/p\u003e \u003cp\u003e1.7 The Windows Registry.\u003c\/p\u003e \u003cp\u003e1.8 Regional settings.\u003c\/p\u003e \u003cp\u003e1.9 Software development.\u003c\/p\u003e \u003cp\u003e1.10 APL and Windows API.\u003c\/p\u003e \u003cp\u003e1.11 The future challenge.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2 - Advanced APL Techniques\u003c\/b\u003e.\u003c\/p\u003e \u003cp\u003e2.1 Removing legacy code clutter.\u003c\/p\u003e \u003cp\u003e2.2 Bit-wise Boolean techniques.\u003c\/p\u003e \u003cp\u003e2.3 Managing workspace variables.\u003c\/p\u003e \u003cp\u003e2.4 Generating test data.\u003c\/p\u003e \u003cp\u003e2.5 APL+Win as an ActiveX Server.\u003c\/p\u003e \u003cp\u003e2.6 Debugging applications.\u003c\/p\u003e \u003cp\u003e2.7 Functions with methods.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3 -\u003c\/b\u003e \u003cb\u003eApplication Interface\u003c\/b\u003e.\u003c\/p\u003e \u003cp\u003e3.1 Managing the hidden interface.\u003c\/p\u003e \u003cp\u003e3.2 The user interface.\u003c\/p\u003e \u003cp\u003e3.3 The user interface is the application.\u003c\/p\u003e \u003cp\u003e3.4 APL+Win design safeguards.\u003c\/p\u003e \u003cp\u003e3.5 Context sensitive help.\u003c\/p\u003e \u003cp\u003e3.6 Help format as a user option.\u003c\/p\u003e \u003cp\u003e3.7 Application messages.\u003c\/p\u003e \u003cp\u003e3.8 User-defined properties of the system object.\u003c\/p\u003e \u003cp\u003e3.9 The scope of user documentation.\u003c\/p\u003e \u003cp\u003e3.10 Designing menus.\u003c\/p\u003e \u003cp\u003e3.11 Designing forms.\u003c\/p\u003e \u003cp\u003e3.12 Access control.\u003c\/p\u003e \u003cp\u003e3.13 Empower the user.\u003c\/p\u003e \u003cp\u003e3.14 Sales considerations.\u003c\/p\u003e \u003cp\u003e3.15 Application exit.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4 -\u003c\/b\u003e \u003cb\u003eWorking with Windows\u003c\/b\u003e.\u003c\/p\u003e \u003cp\u003e4.1 The APL legacy.\u003c\/p\u003e \u003cp\u003e4.2 Windows resources.\u003c\/p\u003e \u003cp\u003e4.3 API calls.\u003c\/p\u003e \u003cp\u003e4.4 The Windows Script Host (WSH).\u003c\/p\u003e \u003cp\u003e4.5 Creating a shortcut.\u003c\/p\u003e \u003cp\u003e4.6 Intelligent file operations with API calls.\u003c\/p\u003e \u003cp\u003e4.7 Universal Naming Convention (UNC).\u003c\/p\u003e \u003cp\u003e4.8 Application configuration.\u003c\/p\u003e \u003cp\u003e4.9 Using INI files with APL.\u003c\/p\u003e \u003cp\u003e4.10 XML files for application configuration.\u003c\/p\u003e \u003cp\u003e4.11 INI\/XML comparative advantage.\u003c\/p\u003e \u003cp\u003e4.12 The filing system.\u003c\/p\u003e \u003cp\u003e4.13 Platform enhancements.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5 -\u003c\/b\u003e \u003cb\u003eThe Component Object Model\u003c\/b\u003e.\u003c\/p\u003e \u003cp\u003e5.1 Objects are global.\u003c\/p\u003e \u003cp\u003e5.2 APL+Win COM event handling.\u003c\/p\u003e \u003cp\u003e5.3 The promise of COM development.\u003c\/p\u003e \u003cp\u003e5.4 Types of COM components.\u003c\/p\u003e \u003cp\u003e5.5 Maintaining objects.\u003c\/p\u003e \u003cp\u003e5.6 APL+Win and ActiveX components.\u003c\/p\u003e \u003cp\u003e5.7 APL+Win post version 4.0 ActiveX syntax.\u003c\/p\u003e \u003cp\u003e5.8 ActiveX typed parameters.\u003c\/p\u003e \u003cp\u003e5.9 Development environment features.\u003c\/p\u003e \u003cp\u003e5.10 Using ActiveX asynchronously.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6 -\u003c\/b\u003e \u003cb\u003eMixed Language Programming\u003c\/b\u003e.\u003c\/p\u003e \u003cp\u003e6.1 Application extension trade-offs.\u003c\/p\u003e \u003cp\u003e6.2 VB ActiveX DLLs.\u003c\/p\u003e \u003cp\u003e6.3 A sample ActiveX DLL project.\u003c\/p\u003e \u003cp\u003e6.4 Using VBDLLINAPL.DLL.\u003c\/p\u003e \u003cp\u003e6.5 Processing APL+Win arrays.\u003c\/p\u003e \u003cp\u003e6.6 Deploying ActiveX DLLs.\u003c\/p\u003e \u003cp\u003e6.7 Building a DLL for APL using C# Express 5.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7 -\u003c\/b\u003e \u003cb\u003eApplication Extension using Scripting\u003c\/b\u003e.\u003c\/p\u003e \u003cp\u003e7.1 The APL\/VBScript affinity.\u003c\/p\u003e \u003cp\u003e7.2 Error trapping.\u003c\/p\u003e \u003cp\u003e7.3 Exploring the Script Control.\u003c\/p\u003e \u003cp\u003e7.4 Extending the Script Control.\u003c\/p\u003e \u003cp\u003e7.5 Multi-language programming.\u003c\/p\u003e \u003cp\u003e7.6 Sharing with the APL Grid object.\u003c\/p\u003e \u003cp\u003e7.7 Concurrent sharing with the Script Control.\u003c\/p\u003e \u003cp\u003e7.8 APL+Win and HTML.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8 -\u003c\/b\u003e \u003cb\u003eWindows Script Components\u003c\/b\u003e.\u003c\/p\u003e \u003cp\u003e8.1 Building a Script Component using JavaScript.\u003c\/p\u003e \u003cp\u003e8.2 Building a Script Component using VBScript.\u003c\/p\u003e \u003cp\u003e8.3 About the VBS file.\u003c\/p\u003e \u003cp\u003e8.4 Runtime errors in script components.\u003c\/p\u003e \u003cp\u003e8.5 Which Scripting language?\u003c\/p\u003e \u003cp\u003e8.6 Multi-language Script component.\u003c\/p\u003e \u003cp\u003e8.7 What is in MULTILANGUAGE.WSC?\u003c\/p\u003e \u003cp\u003e8.8 Finally, just because it is possible….\u003c\/p\u003e \u003cp\u003e8.9 The way forward with script components.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9 -\u003c\/b\u003e \u003cb\u003eWorking with Excel\u003c\/b\u003e.\u003c\/p\u003e \u003cp\u003e9.1 Application or automation server.\u003c\/p\u003e \u003cp\u003e9.2 The basic structure of Excel.\u003c\/p\u003e \u003cp\u003e9.3 APL arrays and Excel ranges.\u003c\/p\u003e \u003cp\u003e9.4 Object syntax.\u003c\/p\u003e \u003cp\u003e9.5 Excel using APL+Win to retrieve APL data.\u003c\/p\u003e \u003cp\u003e9.6 The Excel Add-In.\u003c\/p\u003e \u003cp\u003e9.7 The EWA model in action.\u003c\/p\u003e \u003cp\u003e9.8 Transferring APL+Win data to Excel.\u003c\/p\u003e \u003cp\u003e9.9 Automation issues.\u003c\/p\u003e \u003cp\u003e9.10 Why use Excel with APL?\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10 -\u003c\/b\u003e \u003cb\u003eWorking with Word\u003c\/b\u003e.\u003c\/p\u003e \u003cp\u003e10.1 The Word difference.\u003c\/p\u003e \u003cp\u003e10.2 Word templates.\u003c\/p\u003e \u003cp\u003e10.3 Starting Word.\u003c\/p\u003e \u003cp\u003e10.4 Word as a report generation component.\u003c\/p\u003e \u003cp\u003e10.5 Populating form fields.\u003c\/p\u003e \u003cp\u003e10.6 Word vs. Excel for APL+Win automation.\u003c\/p\u003e \u003cp\u003e10.7 Automation.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 11 -\u003c\/b\u003e \u003cb\u003eWorking with Access\u003c\/b\u003e.\u003c\/p\u003e \u003cp\u003e11.1 The Access pathways.\u003c\/p\u003e \u003cp\u003e11.2 The Access object.\u003c\/p\u003e \u003cp\u003e11.3 JET Engine types.\u003c\/p\u003e \u003cp\u003e11.4 Access—below the surface.\u003c\/p\u003e \u003cp\u003e11.5 Working with many data sources.\u003c\/p\u003e \u003cp\u003e11.6 Troubleshooting data projects.\u003c\/p\u003e \u003cp\u003e11.7 The Jet compromise.\u003c\/p\u003e \u003cp\u003e11.8 Unified approach with ADO and SQL.\u003c\/p\u003e \u003cp\u003e11.9 Access SQL.\u003c\/p\u003e \u003cp\u003e11.10 Database filing.\u003c\/p\u003e \u003cp\u003e11.11 Automation issues.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 12 -\u003c\/b\u003e \u003cb\u003eWorking with ActiveX Data Object (ADO)\u003c\/b\u003e.\u003c\/p\u003e \u003cp\u003e12.1 Translating code examples into APL+Win.\u003c\/p\u003e \u003cp\u003e12.2 The connection object.\u003c\/p\u003e \u003cp\u003e12.3 The record object.  \u003c\/p\u003e \u003cp\u003e12.4 The data source catalogue.\u003c\/p\u003e \u003cp\u003e12.5 Learning ADO.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 13 -\u003c\/b\u003e \u003cb\u003eData Source Connection Strategies\u003c\/b\u003e.\u003c\/p\u003e \u003cp\u003e13.1 The application handle.\u003c\/p\u003e \u003cp\u003e13.2 The DSN overhead.\u003c\/p\u003e \u003cp\u003e13.3 Automating user\/system DSN creation.\u003c\/p\u003e \u003cp\u003e13.4 The ODBC Data Source Administrator.\u003c\/p\u003e \u003cp\u003e13.5 System DSN connection.\u003c\/p\u003e \u003cp\u003e13.6 User DSN Connection.\u003c\/p\u003e \u003cp\u003e13.7 DSNManager syntax summary.\u003c\/p\u003e \u003cp\u003e13.8 File DSN Connection.\u003c\/p\u003e \u003cp\u003e13.9 UDL connection.\u003c\/p\u003e \u003cp\u003e13.10 DSN-less connection.\u003c\/p\u003e \u003cp\u003e13.11 Server data sources.\u003c\/p\u003e \u003cp\u003e13.12 Access data sources.\u003c\/p\u003e \u003cp\u003e13.13 Excel data sources.\u003c\/p\u003e \u003cp\u003e13.14 Text data sources.\u003c\/p\u003e \u003cp\u003e13.15 Data source issues.\u003c\/p\u003e \u003cp\u003e13.16 Inward APL+Win issues.\u003c\/p\u003e \u003cp\u003e13.17 Outward APL issues.\u003c\/p\u003e \u003cp\u003e13.18 The way forward with the data tier.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 14 -\u003c\/b\u003e \u003cb\u003eStructured Query Language\u003c\/b\u003e.\u003c\/p\u003e \u003cp\u003e14.1 SQL statements.\u003c\/p\u003e \u003cp\u003e14.2 SQL prime culprits.\u003c\/p\u003e \u003cp\u003e14.3 APL and SQL.\u003c\/p\u003e \u003cp\u003e14.4 Learning SQL.  \u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 15 -\u003c\/b\u003e \u003cb\u003eApplication Evolution\u003c\/b\u003e.\u003c\/p\u003e \u003cp\u003e15.1 Application deployment.\u003c\/p\u003e \u003cp\u003e15.2 The next release.\u003c\/p\u003e \u003cp\u003e15.3 Application workspace.\u003c\/p\u003e \u003cp\u003e15.4 APL libraries vs UNC names.\u003c\/p\u003e \u003cp\u003e15.5 Readability.\u003c\/p\u003e \u003cp\u003e15.6 Global variables.\u003c\/p\u003e \u003cp\u003e15.7 Using API calls.\u003c\/p\u003e \u003cp\u003e15.8 Version control.\u003c\/p\u003e \u003cp\u003e15.9 Change management.\u003c\/p\u003e \u003cp\u003e15.10 Legacy management.\u003c\/p\u003e \u003cp\u003e15.11 Indentation.\u003c\/p\u003e \u003cp\u003e15.12 Documentation.\u003c\/p\u003e \u003cp\u003e15.13 Testing.\u003c\/p\u003e \u003cp\u003e15.14 Release.\u003c\/p\u003e \u003cp\u003e15.15 Application listings.\u003c\/p\u003e \u003cp\u003e15.16 Epilogue.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBibliography\u003c\/b\u003e.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eIndex\u003c\/b\u003e.\u003c\/p\u003e","brand":"John Wiley \u0026 Sons Inc","offers":[{"title":"Default Title","offer_id":49525362753879,"sku":"9780470030202","price":69.95,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9780470030202.jpg?v=1731860230","url":"https:\/\/bookcurl.com\/products\/system-building-with-apl-win-9780470030202","provider":"Book Curl","version":"1.0","type":"link"}