Start the road to programming with Xbasic ...
Choose this bundle if you want to learn Xbasic.
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 and Alpha Five!
No posts found
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. . .
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.
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.
Book Specifications:
Size: 8 1/2 X 11
No of pages: 390
Cover: Heavy duty laminate.
Binding: Spiral Binding
Twitter
Linkedin
Our YouTube Channel