4D v14.3
QR SET BORDERS
- 4D Language Reference
-
- Quick Report
-
- QR BLOB TO REPORT
- QR Count columns
- QR DELETE COLUMN
- QR DELETE OFFSCREEN AREA
- QR EXECUTE COMMAND
- QR Find column
- QR Get area property
- QR GET BORDERS
- QR Get command status
- QR GET DESTINATION
- QR Get document property
- QR Get drop column
- QR GET HEADER AND FOOTER
- QR Get HTML template
- QR GET INFO COLUMN
- QR Get info row
- QR Get report kind
- QR Get report table
- QR GET SELECTION
- QR GET SORTS
- QR Get text property
- QR GET TOTALS DATA
- QR GET TOTALS SPACING
- QR INSERT COLUMN
- QR New offscreen area
- QR ON COMMANDUpd
- QR REPORT TO BLOB
- QR REPORTUpd
- QR RUN
- QR SET AREA PROPERTY
- QR SET BORDERS
- QR SET DESTINATIONUpd
- QR SET DOCUMENT PROPERTY
- QR SET HEADER AND FOOTER
- QR SET HTML TEMPLATE
- QR SET INFO COLUMN
- QR SET INFO ROW
- QR SET REPORT KIND
- QR SET REPORT TABLE
- QR SET SELECTION
- QR SET SORTS
- QR SET TEXT PROPERTY
- QR SET TOTALS DATA
- QR SET TOTALS SPACING
QR SET BORDERS
| QR SET BORDERS ( area ; column ; row ; border ; line {; color} ) | ||||||||
| Parameter | Type | Description | ||||||
| area | Longint |
|
Reference of the area | |||||
| column | Longint |
|
Column number | |||||
| row | Longint |
|
Row number | |||||
| border | Longint |
|
Border composite value | |||||
| line | Longint |
|
Line thickness | |||||
| color | Longint |
|
Border color | |||||
The QR SET BORDERS command sets the border style for a given cell.
area is the reference of the Quick Report area.
column is the column number of the cell.
row is the row number of the cell. You can pass either:
- a positive integer value to designate the corresponding subtotal (break) level,
- one of the following constants located in the QR Rows for Properties theme:
Constant Type Value Comment qr detail Longint -2 Detail area of report qr grand total Longint -3 Grand total area qr title Longint -1 Title of report
border is a composite value that indicates which borders of the cell are to be affected. Pass one of the constants from the QR Borders theme:
| Constant | Type | Value | Comment |
| qr bottom border | Longint | 8 | Bottom border |
| qr inside horizontal border | Longint | 32 | Inside horizontal border |
| qr inside vertical border | Longint | 16 | Inside vertical border |
| qr left border | Longint | 1 | Left border |
| qr right border | Longint | 4 | Right border |
| qr top border | Longint | 2 | Top border |
border can contain an accumulation of several values in order to designate several borders simultaneously. For example, a value of 5 passed in border would affect the right and left borders.
line is the thickness of the line:- 0 indicates no line
- 1 indicates a thickness of 1/4 point
- 2 indicates a thickness of 1/2 point
- 3 indicates a thickness of 1 point
- 4 indicates a thickness of 2 points
color is the color of the line:
- If color is a positive value, it indicates a specific color.
- If color equals 0, the color is black.
- If color equals -1, no changes are to be made.
Note: The default color is black.
If you pass an invalid area number, the error -9850 will be generated.
If you pass an invalid column number, the error -9852 will be generated.
If you pass an invalid row number, the error -9853 will be generated.
If you pass an invalid border parameter, the error -9854 will be generated.
If you pass an invalid line parameter, the error -9855 will be generated.
Product: 4D
Theme: Quick Report
Number:
797
Created: 4D 2003
4D Language Reference ( 4D v12.4)
4D Language Reference ( 4D v11 SQL Release 6)
4D Language Reference ( 4D v14 R3)
4D Language Reference ( 4D v14 R2)
4D Language Reference ( 4D v13.5)
4D Language Reference ( 4D v14.3)
4D Language Reference ( 4D v14 R4)
