Save 19%

Web Tech Bundle (A5V11 Desktop, Web)

Save on Combos & Bundles!
List price: $234.75
$189.95
You save: $44.80 (19%)
Unless you specify 3-hole punch, books will be spiral bound.
W11-208A
+

Learn Alpha Anywhere and programming, too ...

Choose this bundle if you are new to Alpha Anywhere web/mobile or want to sharpen your skills and then move on to learning how to further enhance your applications by adding programming.

This bundle includes all the books you see above! Each comes with:

  • A full color printed copy of the book, filled with clear, concise instructions and color screen shots plus Table of Contents and Index.
    • Your choice of Spiral Binding or loose pages, 3-Hole Punched, ready for insertion in your own 3-Ring Binders.
  • CD(s) containing the full contents of the books in PDF format. The PDFs are searchable, printable and each has a Table of Contents and Index. Great for hitting the road.
  • The working databases for the exercises in the books.
  • PLUS free copies of the Electronic Download Editions so you can get started immediately. Automatically added to your order.

Want to know more? Click the "Inside" tab(s) above to see book descriptions, table of contents and sample pages.

All books are fully compatible with Alpha Anywhere!

No posts found

Write a review

Alpha Anywhere Xbasic Workbook

(formerly entitled Alpha Five: Xbasic for Everyone)

by Dr. Peter Wayne

Suitable for Alpha Anywhere and Alpha Five V8-11.

What's inside . . .

  • Discussion of terms, tables, sets, field rules and Action Scripting
  • Understanding Variables and Constants
  • Getting Input and Output
  • Understanding Variable scoping and Namespaces
  • Discussion on Functions, Methods and Properties
  • Using the Interactive Window, Debugger
  • Writing scripts for Events
  • Understanding Table Pointers
  • What you need to know about ordering with Indexes and Queries, Fetching records
  • Xbasic for Xdialog, Objects, Form Properties
  • Editing users and groups for Security
  • Adding memos and external files
  • Creating spreadsheets with Crosstabs and Exports
  • Creating a "month-at-a glance" calendar
  • Using Xbasic in web applications
  • Developing your own Object type
  • Using Xbasic with Javascript, AJAX and XML, ADO, ODBC and ActiveX
  • Upsizing your database with SQL
  • Real life examples for setting up an Aged Accounts Receivable and preventing Duplicate Records, creating Time sheets, adding a Running Balance, a Detail General Ledger and an Audit Trail to your financial reports, as well as scanning in Insurance Card data—and more!

Check out the Table of Contents and then take a look at some sample pages. . .

Chapter 6 - Getting Input and Output
Chapter 25 - Creating a Detail General Ledger
Chapter 30 - Xbasic control of Form Properties

Book Specifications:
Size: 8 1/2 X 11
No of pages: 456
Cover: Heavy duty laminate.
Binding: Spiral Binding

The 2008 edition was written for Alpha Five Version 8, but, is also applicable to Alpha Anywhere and Alpha Five Versions 8-11.

 

Alpha Five Functions Handbook

Functions and Expressions Made Easy

Fully compatible with Alpha Anywhere and Alpha Five

What's inside . . .

Ch 1: The Basics
Once understood, most common functions are easy to use. Expressions can define calculations or combine fields with text, always following a consistent format throughout the program.

Ch 2: Character Functions
From changing the case of a letter to creating expressions for importing data, character type functions can manipulate both simple and complex data.

Ch 3: Date and Time Functions
Dates can be formatted in a variety of styles. One date subtracted from another, results in the number of days between the two. You can also calculate the time worked by an employee or show the duration of time of sporting event.

Ch 4: Numeric Functions
From simple arithmetic to advanced calculations, numeric functions give superior results.

Ch 5: Functions for Filtering and Ordering Records
Whether locating a single record within tens of thousands or printing a monthly sales report, filtering is at the heart of your application design.

Ch 6: Summary and Report Functions
Totals, averages, counts and other summaries will have your reports telling the whole story for you and your clients.

Ch 7: Lookup Function
The Lookup function requires more documentation than other functions because the syntax can be hard to understand. After doing the exercise and reading the principles behind its setup, just use the worksheet at the end of the chapter and you'll easily add lookups to your application!

Many thanks to Frances Peake for her assistance with this chapter.

Ch 8: Table Information
You can return the name of the table, the record number and other information about fields and tables.

Ch 9: Master Chart
When you know the name of the function, come here for quick reference to the syntax.

Check out the Table of Contentsand List of Syntax Charts and then take a look at some sample pages . . .

Ch 2: Character Functions and sample syntax chart

Book Specifications:
Size: 8 1/2 X 11
No of pages: 196
Cover: Heavy duty laminate.
Binding: Spiral Binding

 

Alpha Five Xbasic Toolbox

Writing Code Made Easy

Fully compatible with Alpha Anywhere and Alpha Five V11

 

What's inside . . .

Ch 1: Learn the Basics!
Basic terminology, script syntax, running a script, understanding the Code Editor and Interactive Window.

Ch 2: Compose the code!
Learn all about variables and how to write expressions. Get the details on properties, methods, objects and sub-objects. Discusses object events and addresses, as well as manipulating them to accomplish your goals. Bubble help makes writing scripts quick and eash.

Ch 3: Get the bugs out!
The Alpha Five Debugger is a valuable tool that should be understood by all developers.

Ch 4: Refine the script!
Learn about variable scoping and where variables are defined, as well as pointer, dot and array variables. Create global (user defined) functions and dlalog boxes. Also discusses classes and enumeration.

Ch 5: Take Action! Save Energy!
Employ Action Scripting and Action JavaScript. Create dialog and message boxes.

Ch 6: Take it to the world!
How and where to write code for web applications. Understanding the client-server model. When and how to use JavaScript. Creating an AEX Library and saving functions for future use.

Ch 7: Create AJAX Callbacks!
This section uses a set of videos as its inspiration. Learn what AJAX callbacks are and how they are written.

Ch 9: Get Help!
Alpha Five has thousands of pages that assist in script writing. Learn how to use the Documentation Viewer and Video Finder to find treasures tucked inside these valuable resources.

Ch 9: Like the tools!
Review of tools discussed in the book. More on the Debugger, Interactive and Libraries. How to create a Connection String and where to get more information on Xbasic.

Check out the Table of Contents and then take a look at some sample pages . . .

Ch 1: Learn the basics!

Ch 6: Take it to the world!

This book uses a database supplied with Alpha Five / Alpha Anywhere.

Book Specifications:
Size: 8 1/2 X 11
No of pages: 264
Cover: Heavy duty laminate.
Binding: Spiral Binding

Alpha Anywhere Functions Directory

Finding Functions and Methods Made Easy (AA & A5V5-11)

Fully compatible with Alpha Anywhere

 

What's inside . . .

Ch 1: Getting Started
This book is designed for use with the Documentation Viewer that is built into Alpha Anywhere and Alpha Five V11. (Users with earlier versions can use the Alpha Five Help files.)

Ch 2: Core and Script Writing
Most often used functions and those for arrays, collection methods, script, trace functions and variable functions. You will find the Repository and Work Queue very useful.

Ch 3: Character Types
Character addition, case, comparison, compression, conversion, counting, extraction, formatting, replacement, searching, sorting and list processing. Also regular (Regex) and type checking functions.

Ch 4: Date and Time Types
Date arithmetic, calendar, general, calculation, conversion and formatting functions. Predefined date formats, date and time format elements, date and time conversion matrix.

Ch 5: Numeric and Logical Types
Arithmetic operators, mathematical and financial functions, including Authorize.net. Logical methods and operators. Comparison operators.

Ch 6: Queries, Expression Evaluating and Type Checking
Queries, expression evaluation, record searches, type checking functions and methods.

Ch 7: Reporting
Charting, Reporting, XML and XPS functions and methods.

Ch 8: Specialty Areas
Addressing & tracking, blob, color, connection strings, email, error, graphics, sets, StringDictionary, StringScanner, web component functions and methods.

Ch 9: System Formats
Dictionary, directory, file, filefind, filename, Importing, index, performance, registry, shadow database, system and thread functions and methods.

Ch 10: Alpha Anywhere Fields, Records & Tables
Field, record and table functions, including those for Active Link tables.

Ch 11: SQL Data Type
Portable SQL, SQL basics. Functions and methods for the following SQL Objects: Argument, CallResult, Connection, Data TypeInfo, IndexColumnInfo, IndexInfo, ResultSet, Row, Schema, TableInfo. Also functions for use with SQL geographic databases and enumerated types.

Ch 12: javaScript
Using JavaScript with Alpha Anywhere and the Alpha Anywhere JavaScript Core Library
. Using JSON with Alpha Five. Session variables and Client-side calculations.

Ch 13: Desktop: Layouts
Browses, forms, labels, layout objects, letters, reports and printing functions and methods.

Ch 14: Desktop: Control Panel
Control panel, database, menus, objects, operations, status bar, system, thread, toobar, URL & IP addresss, Web App server and window functions.

Ch 15: Desktop: Dialogs
User interaction and Xdialog functions and methods.

Ch 16: Desktop: Specialty Areas
User interaction and Xdialog functions and methods.

Ch 17: Web & Mobile Applications
Basic web and mobile app functions. Security and encodinf functions. OLE & ActiveX methods.

Check out the Table of Contentsand Sample pages from Chapters 3 & 11.


Book Specifications:
Size: 8 1/2 X 11
No of pages: 390
Cover: Heavy duty laminate.
Binding: Spiral Binding


 

Alpha Five Web Applications Made Easy

The Basics and More for Version 11

What's inside . . .

  • Ch 1: Sensational System: How designing for the web with Alpha Five is unique.
  • Ch 2: Marvelous Moves: Introduction to Web Components, the heart of the Alpha Five web system
  • Ch 3: Heavenly Help: Learn how to find all the help you need with the Documentation Viewer and Video Finder.
  • Ch 4: Solid Security: Keep the bad guys out with the Application Server's security system.
  • Ch 5: Amazing Attributes: The Web Application Control Panel is packed with feature after feature after feature.
  • Ch 6: Setup Settings: Templates, types of grids, tables and views. Learn all you need to know!
  • Ch 7: Fun with Fields: Forms and frames and links and lookups lead to great grids!
  • Ch 8: Dynamite Dialogs: Learn all about the component that talks to your users and readies you for mobile.
  • Ch 9: Perfect Packages: Put everything together with the Tabbed UI, Page Layout and Navigations System components and learn about the free Feature Packs.
  • Ch 10: Sexy SQL Secrets: Connect to your remote database and use Alpha Five's user friendly features at the same time.
  • Ch 11: Internet Installation: What you need to do to take the final steps of putting your application on-line.
  • Ch 12: Helpful Hints: More morsels of interesting information!

Appendix: A pictorial review of components so you can choose just the right one while you are working on your application!

Check out the Table of Contents and then take a look at some sample pages . . .

Chapter 7: Fun with Fields: Add lookups and lots more special features.

Chapter 8: Dynamite Dialogs: Just a sampling of what these amazing components can do.

Chapter 9: Perfect Packages:More web components and free Feature Packs!

Book Specifications:

Size: 8 1/2 X 11
No of pages: 510
Cover: Heavy duty laminate.
Binding: Spiral Binding