Category: Using Query’s
-
Fetching Forms and Reports using Queries in Alpha Software
In our last exercise we looked at using queries controlled by variables to fetch and display a range of records in a form as well as using the table method to step through the child records to populate a rich text object with memo fields from the child records. In this exercise I will demonstrate…
-
Understanding Queries in Alpha Software
—
by
in .queryrun, batch_Begin, Changing Object Property Values, Converting Data Types, Declaring Variables on a Form, Fetch, Fetch_Last, fetch_Next, Form Design, How To, King James Bible Reader, List Object, List Objects, Memo Fields, Object Explorer, Object Method, ON Change, On Init, On Push, Radio Object, wordIn this current age of application development it is not enough to create an application which looks good and does what it was intended to do, it must also be fast. In Alpha Software when you create a table or set you will most likely create one or more index’s for controlling your data view.…
-
Programming Developers Diary – 03
—
by
in .queryrun, Declaring Variables on a Form, Design Document, Desktop Application, Developers Diary, External_Record_Content_Get, Fetch, fetch_Next, Form Design, Handling Errors, How To, On Event, On Push, Table Open Method, Tables and Sets, Using goto label, Using If Else if, Using Query’s, XBasic Tips and TricksJanuary 13,2017 Hello everyone. I have completed the receivables module upgrade for my customer and did the thing I hate most but must do which is check my work. Typically I test my work as I go along but those test work on the norm rather than the exception. We all know in the business…
-
Incorporating xBasic into Form Design: 11
—
by
in .queryrun, Changing Object Property Values, Conditional Object, Declaring Variables on a Form, Fetch, Form Design, How To, List Objects, Object Method, ON Change, On Event, On Init, On Push, Progressive Lookups, Radio Object, Table Open Method, Tables and Sets, Using Query’s, XBasic Tips and TricksHello everyone Today we will look at using xBasic to control multiple browses on a single form designed on a set with one to many links to five separate tables. This example comes from our Managers Workbook in our Restaurant Back Office software application and is written in version 8 of Alpha Software. Purpose of…
-
Incorporating xBasic into Design 05
—
by
in .queryrun, Append, Changing Object Property Values, Custom Super Controls, Declaring Variables on a Form, Desktop Application, Fetch, fetch_Next, Form Design, How To, List Objects, ON Change, On Event, On Push, Operations, Posting, Table Open Method, tablecount, Tables and Sets, Using Query’s, XBasic Tips and TricksHello everyone Designing forms in Alpha Software is very easy using the Drag and Drop tools and simple set design wizard. Forms designed this way are bound to the underlying table which is OK based on the use of the form. For example, data entry forms should be bound to the table so as to…
-
Programming Chess in Alpha Software: Lesson6
—
by
in Changing Object Property Values, Desktop Application, External_Record_Content_Get, Fetch, Form Design, Form Load Method, Games, Having Fun With Graphics, How To, List Objects, Object Method, On Event, On Fetch, On Init, On Push, Programming A Chess Game, Record List Combo, Table Open Method, Tree View, Using If Else if, Using Query’s, Writing Array’s, XBasic Tips and TricksHello Everyone Today we will be looking at the opening book for our chess program and the code for all the functions related to the opening book. Before we begin please take a moment to watch this short video which demonstrated the use of the opening book and the new features we are adding to…
-
Powerball Random Number Generator Lesson Three
Hello everyone As I mentioned in the last post we would discuss how to build a data analyzer for our Powerball Game. The principles we will discuss go beyond our game and can be used in all types of database applications. When designing an application for a business regardless of the development platform or the…
Custome Database Design with Alpha Software 