Index of NotesThese are my personal notes that I use as a quick help in my work.
|
|
These are my personal notes
See also index.html
ISO 8601 for dates, times, and durations (Wikipedia).
Summary: YYYY-MM-DDThh:mm:ss
(the "T
" can be omitted)
Screen
Keyboard and mouse
Table
Chair
Miscellaneous
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
Template for simple table |
---|
<table border=1 cellpadding="3" cellspacing="0"> |
See more in file HowTo