System Building with APL + WIN / Edition 1

Paperback (Print)
Buy New
Buy New from
Used and New from Other Sellers
Used and New from Other Sellers
from $69.57
Usually ships in 1-2 business days
(Save 27%)
Other sellers (Paperback)
  • All (7) from $69.57   
  • New (5) from $69.57   
  • Used (2) from $137.57   


Software modernisation or re-engineering as a concept lacks universal clarity. System Building with APL + Win 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.

  • Demonstrates the power and agility of APL + Win in today’s approach to system building
  • Features a ‘code intensive’ approach, which overcomes the lack of APL+Win specific documentation of system components
  • Illustrates the potential for multi-language system building from an APL+Win environment
  • Explains how increasing the collaborative nature of APL will enable it to become an even more valuable tool for application development

System Building with APL + Win provides an excellent resource for system developers and training providers using the software, as well as MS Office users who wish to incorporate it into a bespoke application development. It will also be of interest to users of other APL interpreters.

RSP Series in Industrial Control, Computers and Communications

Read More Show Less

Product Details

  • ISBN-13: 9780470030202
  • Publisher: Wiley
  • Publication date: 9/1/2006
  • Series: RSP Series, #6
  • Edition number: 1
  • Pages: 524
  • Product dimensions: 6.67 (w) x 9.61 (h) x 1.21 (d)

Meet the Author

Ajay Askoolum works for Claybrook Computing Ltd. In Surrey. Having obtained an MSc in Economics, he has worked in the pensions software sector of the UK insurance industry and has over 20 years’ experience using APL andn has authored a number of journal articles on the topic.

Read More Show Less

Table of Contents

Editorial Foreword.



Chapter 1 - System Building Overview.

1.1 Why APL?

1.2 Which APL?

1.3 The n-tier model.

1.4 Prevailing design architecture.

1.5 APL interface to components.

1.6 Structured Query Language (SQL).

1.7 The Windows Registry.

1.8 Regional settings.

1.9 Software development.

1.10 APL and Windows API.

1.11 The future challenge.

Chapter 2 - Advanced APL Techniques.

2.1 Removing legacy code clutter.

2.2 Bit-wise Boolean techniques.

2.3 Managing workspace variables.

2.4 Generating test data.

2.5 APL+Win as an ActiveX Server.

2.6 Debugging applications.

2.7 Functions with methods.

Chapter 3 - Application Interface.

3.1 Managing the hidden interface.

3.2 The user interface.

3.3 The user interface is the application.

3.4 APL+Win design safeguards.

3.5 Context sensitive help.

3.6 Help format as a user option.

3.7 Application messages.

3.8 User-defined properties of the system object.

3.9 The scope of user documentation.

3.10 Designing menus.

3.11 Designing forms.

3.12 Access control.

3.13 Empower the user.

3.14 Sales considerations.

3.15 Application exit.

Chapter 4 - Working with Windows.

4.1 The APL legacy.

4.2 Windows resources.

4.3 API calls.

4.4 The Windows Script Host (WSH).

4.5 Creating a shortcut.

4.6 Intelligent file operations with API calls.

4.7 Universal Naming Convention (UNC).

4.8 Application configuration.

4.9 Using INI files with APL.

4.10 XML files for application configuration.

4.11 INI/XML comparative advantage.

4.12 The filing system.

4.13 Platform enhancements.

Chapter 5 - The Component Object Model.

5.1 Objects are global.

5.2 APL+Win COM event handling.

5.3 The promise of COM development.

5.4 Types of COM components.

5.5 Maintaining objects.

5.6 APL+Win and ActiveX components.

5.7 APL+Win post version 4.0 ActiveX syntax.

5.8 ActiveX typed parameters.

5.9 Development environment features.

5.10 Using ActiveX asynchronously.

Chapter 6 - Mixed Language Programming.

6.1 Application extension trade-offs.

6.2 VB ActiveX DLLs.

6.3 A sample ActiveX DLL project.


6.5 Processing APL+Win arrays.

6.6 Deploying ActiveX DLLs.

6.7 Building a DLL for APL using C# Express 5.

Chapter 7 - Application Extension using Scripting.

7.1 The APL/VBScript affinity.

7.2 Error trapping.

7.3 Exploring the Script Control.

7.4 Extending the Script Control.

7.5 Multi-language programming.

7.6 Sharing with the APL Grid object.

7.7 Concurrent sharing with the Script Control.

7.8 APL+Win and HTML.

Chapter 8 - Windows Script Components.

8.1 Building a Script Component using JavaScript.

8.2 Building a Script Component using VBScript.

8.3 About the VBS file.

8.4 Runtime errors in script components.

8.5 Which Scripting language?

8.6 Multi-language Script component.


8.8 Finally, just because it is possible….

8.9 The way forward with script components.

Chapter 9 - Working with Excel.

9.1 Application or automation server.

9.2 The basic structure of Excel.

9.3 APL arrays and Excel ranges.

9.4 Object syntax.

9.5 Excel using APL+Win to retrieve APL data.

9.6 The Excel Add-In.

9.7 The EWA model in action.

9.8 Transferring APL+Win data to Excel.

9.9 Automation issues.

9.10 Why use Excel with APL?

Chapter 10 - Working with Word.

10.1 The Word difference.

10.2 Word templates.

10.3 Starting Word.

10.4 Word as a report generation component.

10.5 Populating form fields.

10.6 Word vs. Excel for APL+Win automation.

10.7 Automation.

Chapter 11 - Working with Access.

11.1 The Access pathways.

11.2 The Access object.

11.3 JET Engine types.

11.4 Access—below the surface.

11.5 Working with many data sources.

11.6 Troubleshooting data projects.

11.7 The Jet compromise.

11.8 Unified approach with ADO and SQL.

11.9 Access SQL.

11.10 Database filing.

11.11 Automation issues.

Chapter 12 - Working with ActiveX Data Object (ADO).

12.1 Translating code examples into APL+Win.

12.2 The connection object.

12.3 The record object.  

12.4 The data source catalogue.

12.5 Learning ADO.

Chapter 13 - Data Source Connection Strategies.

13.1 The application handle.

13.2 The DSN overhead.

13.3 Automating user/system DSN creation.

13.4 The ODBC Data Source Administrator.

13.5 System DSN connection.

13.6 User DSN Connection.

13.7 DSNManager syntax summary.

13.8 File DSN Connection.

13.9 UDL connection.

13.10 DSN-less connection.

13.11 Server data sources.

13.12 Access data sources.

13.13 Excel data sources.

13.14 Text data sources.

13.15 Data source issues.

13.16 Inward APL+Win issues.

13.17 Outward APL issues.

13.18 The way forward with the data tier.

Chapter 14 - Structured Query Language.

14.1 SQL statements.

14.2 SQL prime culprits.

14.3 APL and SQL.

14.4 Learning SQL.  

Chapter 15 - Application Evolution.

15.1 Application deployment.

15.2 The next release.

15.3 Application workspace.

15.4 APL libraries vs UNC names.

15.5 Readability.

15.6 Global variables.

15.7 Using API calls.

15.8 Version control.

15.9 Change management.

15.10 Legacy management.

15.11 Indentation.

15.12 Documentation.

15.13 Testing.

15.14 Release.

15.15 Application listings.

15.16 Epilogue.



Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)