Index of Notes

Contents

• Introduction
• Abbreviations
• Hardware troubleshooting
• Standards
• Ergonomy
• Genio
• Miscellaneous

Introduction

These are my personal notes

See also index.html

Abbreviations

IDE

Integrated Development Environment

Standards

ISO 8601 for dates, times, and durations (Wikipedia). Summary: YYYY-MM-DDThh:mm:ss (the "T" can be omitted)

Ergonomy

Screen

• Best distance to screen: 50-80 cm.
• Screen in front of user; if the user is mostly working on documents, then the documents should be directly in front of the user and screen behind or to the side.
• Screen slightly lower than the eyes (line of sight 30° downwards).
• Try to remove reflections on screen.

Keyboard and mouse

• At least 20 cm from the each of the table (?) or enough to let wrist rest on table.
• Keyboard as flat as possible (middle line with "A", "S", "D" no more than 3 cm from the table surface)
• Keyboard inclination of 5° to 15°.
• A wristpad is more confortable.
• The hand should be able to rest on the mouse (?).

Table

• Best: wood 120 cm wide and 100 cm deep (less for flat screens)
• Height: forearms rest flat (68 - 84 cm high). For standing: 120 cm.

Chair

• Elbows and knees at 90° angles (inner knee 3 cm below chair surface)
• Top of backrest slightly forward
• Armrests are not useful

Miscellaneous

• At least 2mm between lines of a document

Genio

New module: use wizard and autofill. Then add:

ForEach
    Filter True
    // update row
    UpdateRow THE_TABLE
        Filter PRIMARY_KEY
        Field f1 = TRIM(whatever)
        Field SIGNED = IF UPPER(TRIM(y_n_field))="Y" THEN -1 ELSE 0
        Field a_date = IF number_as_date =0 then NULL else [Num_to_date] ( number_as_date )
    If @rowsaffected=0 Then
        // The row does not exist, so insert
        AddRow THE_TABLE
            Field PRIMARY_KEY = the_data
            // the rest is same as above
            Field f1 = TRIM(whatever)
            Field SIGNED = IF UPPER(TRIM(y_n_field))="Y" THEN -1 ELSE 0
            Field a_date = IF number_as_date =0 then NULL else [Num_to_date] ( number_as_date )
    Else
    EndIf
EndForEach
If @Error <> 0 Then
    Write Console = "ERROR ON THE_TABLE TABLE "
    Write Console = "__________________________________ "
    Write Console = "End of module : @Error="&STRING(@Error)&"; @DbError="&STRING(@DbError)&"; @ReturnCode="&STRING(@ReturnCode)&"."
Else
    // All OK
    Write Console = "OK LOADING ON THE_TABLE TABLE "
    Write Console = "End of module : @Error="&STRING(@Error)&"; @DbError="&STRING(@DbError)&"; @ReturnCode="&STRING(@ReturnCode)&"."
EndIf

M_module
D_dataset
P_rocedure
V_ariable

Miscellaneous

See more in file HowTo