arealist_pro_v10_new_commands
Table of Contents
MySQL access
| command | syntax |
|---|---|
| AL_SetMySQLSource | (areaRef:L; host:T; user:T; password:T; schema:T; options:T; port:L; statement:T; parameter1:Z; parameter2:Z; … parameter17:Z) → error:L |
General
| command | syntax |
|---|---|
| AL_MoveColumn | (areaRef:L; from:L; insertAt:L) → error:L |
| AL_DuplicateColumn | (areaRef:L; columnID:L; sourcePtr:Z; insertAt:L) → error:L |
Break processing commands
See the PrintList Pro v5 manual for details about break processing.
| command | syntax |
|---|---|
| AL_SetBreakPtrProperty | (areaRef:L; header:L; level:L; cellNumber:L; property:T; value:Z) → error:L |
| AL_SetBreakLongProperty | (areaRef:L; header:L; level:L; cellNumber:L; property:T; value:Z) → error:L |
| AL_SetBreakRealProperty | (areaRef:L; header:L; level:L; cellNumber:L; property:T; value:8) |
| AL_SetBreakTextProperty | (areaRef:L; header:L; level:L; cellNumber:L; property:T; value:T) |
| AL_GetBreakPtrProperty | (areaRef:L; header:L; level:L; cellNumber:L; property:T; value:Z) → error:L |
| AL_GetBreakLongProperty | (areaRef:L; header:L; level:L; cellNumber:L; property:T) → value:L |
| AL_GetBreakRealProperty | (areaRef:L; header:L; level:L; cellNumber:L; property:T) → value:8 |
| AL_GetBreakTextProperty | (areaRef:L; header:L; level:L; cellNumber:L; property:T) → value:T |
How to use the commands above:
header: 0 = footer, 1 = header
level: 0 - 64
cellNumber: 0 to apply to the break, > 0 to apply to the individual cell
if cellNumber is zero, usable properties are:
- ALP_Break_RowID
- ALP_Break_NumRowLines
- ALP_Break_MinRowHeight
- ALP_Break_RowIndent
- ALP_Break_RowIndentH
- ALP_Break_RowIndentV
Use ALP_Area_RowsInGrid to set the number of lines (cells) in each column break.
otherwise:
- ALP_Cell_Value: the break value (string which can use the “\\SUM” and other functions evaluated in the break processing
| command | syntax |
|---|---|
| AL_SetBreakObjects | (areaRef:L; header:L; level:L; property:T; array:Y) → error:L |
| AL_GetBreakObjects | (areaRef:L; header:L; level:L; property:T; array:Y) → error:L |
The only property is ALP_Object_Grid → use 2D array
Other break processing properties:
- ALP_Break_HeaderCalcMethod: method for handling break header's “\\FUNCTION”
- ALP_Break_FooterCalcMethod: method for handling break footer's “\\FUNCTION”
- ALP_Break_HideDetails
arealist_pro_v10_new_commands.txt · Last modified: 2017/09/27 15:27 by alp_admin
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
