Customers Also Bought Customers Also Bought

Save 25%

Hard Copy - Functions Directory (AA & A5V5-12 Desktop, Web, Mobile)

All books available in Hard Copy, Book on CD and Electronic Download Edition. Save on Combos & Bundles.

List price: $39.95
You save: $10.00 (25%)
Unless you specify 3-hole punch, books will be spiral bound.

Nothing beats the hard copy!

The moment this book arrives, you will know you made the right decision because you have full color for the price of black and white at the copy center.

Here's what you get:

  • 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 Binder.
  • A CD containing the full contents of the book in PDF format. The PDF is searchable, printable and includes the Table of Contents and Index. Great for hitting the road.
  • (This book is designed as a reference and uses the Alpha help files for syntax. There is no companion database.)
  • A free copy of the Electronic Download Edition 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.

This book is compatiable with Alpha Anywhere and Alpha Five.

Save on Combos & Bundles!

No posts found

Write a review

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 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 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