Index of Notes

  

These are my personal notes that I use as a quick help in my work.
You are welcome to read them.

Contents of current page Top-level home page
 
Index  Java Internet Oracle Notes
Linux Basics Web Basics SQL Notes
Informatica Servlets Apache BkpRstore SQL*Plus
Teradata   LDAP Storage PL/SQL
Windows     Tables OEM
UML   Net8 Portal
SQL Server Python perl Performance OLAP
Vmware Visual Basic PHP/MySQL User Mgmt  
Git        
More technical pages here

Contents

 


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

Keyboard and mouse

Table

Chair

Miscellaneous

 

 


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

 

 

Template for simple table
<table border=1 cellpadding="3" cellspacing="0">
<tr><th>Header</th></tr>
<tr><td><code>&nbsp;&nbsp;</code></td></tr>
</table>

See more in file HowTo

 

 


 

Another topic