PROGRAMMING INSTRUCTIONS

This sample data entry program captures sales transactions that include amounts. When [Compute] button is clicked, the Total is computed.

To add the programming instructions to [Compute] button, the program is flipped from execute to design mode by clicking the hammer icon:

 

At design mode, the command editor screen (below) is used to add instructions. 

 

An instruction consists of: operand1, operation, operand2 and operand3 which are selected from the drop down lists. 

Two lines of instructions are added and the program returns to execute mode. 

 

When [Compute] is clicked, Amount, Amount2 and Amount3 are added into Total.

 

 

Programming instructions may be added to Create, Modify, Delete and Compute buttons. The special command, Debug Next Command, verifies the accuracy of programming instructions:

 

 

Below is a list of operations.

 

   

DATA ENTRY PROGRAMS

Calculations

add x to y giving z

divide x by y giving z

multiply x by y giving z

subtract x from y giving z

add n days to a date

add n weeks to a date

add n months to a date

add n years to a date

get no. of elapsed days

get no. of elapsed weeks

get no. of elapsed months

get no. of elapsed years

 

Data Assignments

assign value-x to data-y

concatenate x and y giving z

 st + reet becomes street

default entry

error message

get first n characters of data

get last n characters of data

warning message

 

Comparisons

number x is between y and z

   as in 5 is between 1 and 10

text x between y and z, as in

   Mary is between John and Matt

x must equal y

x must be greater

x's length must be equals y

x's length must be greater y

x's length must be less than y

number x must be less than y

  as in 120 is less than 1000

text x must be less than y

  so text '1000' is less than '120'

x is not between y and z

x not equals y

x not greater than y

x not less than y

 

Conditions

Go to step z...

if x is alphabet

if x is amount

if x is blank

if x is blazer (blank or zero)

if x is date

if x equals y

if x excludes y

if number-x is greater y

if text-x is greater y

if x includes y

if number-x is less than y

if text-x is less than y

if x is not alphabet

if x is not amount

if x is not blank

if x is not blazer

if x is not date

if x is not equals

if number-x is not greater y

if text-x is not greater y

if number-x is not less than y

if text-x is not less than y

if x is not a number

if x is not a time

if x is not a zero

if x is a time

if x is zero

if response is [yes/no],

   then the next step is z

next step is z

 

Data Definitions

Reject data if not:

alphabet

amount

blank

blazer (blank or zero)

date

mandatory entry

not alphabet

not amount

not blank

not blazer

not date

 

 

Back

 

 

not number

not time

not zero

number

time

zero

 

Text Formats

case lower

     SMITH becomes smith

case proper name

john smith becomes John Smith

case upper

     john smith becomes JOHN SMITH

 

Amount/Number Formats

decimals

date format

number/amount format

time format

round

 

File Control

add value-x to file-y balance-z

add 1 to file-y counter-z

add 1 to file-y yes-counter-z

add 1 to file-y no-counter-z

write data-x to file-y

get data-x from file-y

subtract value-x from

      balance-z of file-y

subtract 1 from file-y counter-z

subtract 1 from file-y yes-counter-z

subtract 1 from file-y no-counter-z

 

BATCH PROCESSING SELECTION CRITERIA

x equals y

x is greater than y

x is less than y

x is between y and z

x is not equals y

x is not greater than y

x is not less than y

x is not between y and z

x contains y

company contains c, comp, om, any, y

ENQUIRY CRITERIA

Value   Meaning

>100    greater than 100

<200    less than 200

#300    not 300

=499    exactly 499

corp    contains corp

 

Enquiry selects all records that satisfy the entered Values in the nominated x, y, z .. fields

 

ENQUIRY SUMMARY

count the no. of records selected

sum up amounts or numbers

get the average

get the lowest value

from among selected records

get the highest value

count blazers

get the earliest date

get the latest date

REPORT CRITERIA

Memory-resident criteria

          Select data that:

>100    is greater than 100

<200    is less than 200

#300    is not 300

corp    contains corp

 

Other criteria:

x equals y

x is less than y

x is greater than y

x is between y and z

x is not equals y

 

x is not less than y

x is not greater than y

x is not between y and z

today

gets all records whose date-x equals today

yesterday

tomorrow

this week

gets all records whose date-x  belongs to current week

last week

next week

this month

last month

next month

this quarter

last quarter

next quarter

this year

last year

next year

 

FORMULA FOR CREATING DERIVED REPORT COLUMNS

Calculations

add x to y giving z

divide x by y giving z

multiplied x by y giving z

subtract x from y giving z

add n days to a date

add n weeks to a date

add n months to a date

add n years to a date

elapsed days

elapsed weeks

elapsed months

elapsed years

 

Assignments

assign value-x to data-y

concatenate

get first n characters

get last n characters

system date

system time

 

Conditions

if x equals y

if x is greater than y

if x is less than y

if x not equals y

if x includes y

if x excludes y

if x is blank

if x is blazer

if x is zero

next step

 

Formats

date format

number/amount format

time format

round to n decimal places

 

CHARTS

Actions on Data

average no blanks

get the average of all  records excluding blanks

average no blazers

count

count all

count blanks

count blazers

count all blanks and zeros only

count zeros

sum

 

Conditions

x equals y

x is less than y

x is greater than y

x is between y and z

x is not equals y

x is not greater than y

x is not less than y

x is not between y and z