 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| n |
All continued
code lines must end in <space>_ (an space must
|
|
|
precede the
underscore)
|
|
| n |
All procedures
must be called as if functions:
|
|
xyx(a,b,c) (not xyz a b c).
|
|
| n |
All variables
must be declared before use
|
|
| n |
Preferred: All
variables, parameters, and functions should be typed
|
|
|
(e.g., DIM I
AS Integer). This causes the
code to execute much
|
|
|
faster.
|
|
| n |
Instead of
declaring public variables that are global to all the code,
|
|
|
make variables
public properties of objects that are instantiated and
|
|
call them as
such, e.g., nDefaultIncrement becomes
|
|
|
v.nDefaultIncrement.
|
|
| n |
Added after
evaluations of fields oRS(“…<field name>…”) the
|
|
|
explicit property
specification .Value., e.g.:
|
|
oRS(“ID”).Value (not oRS(“ID”))
|
|
| n |
Recast the code
into vb code modules as described on next slides
|
|