4D v14.3
QR GET 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 GET BORDERS
| QR GET 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 value | |||||
| line | Longint |
|
Line thickness | |||||
| color | Longint |
|
Border color | |||||
The QR GET BORDERS command allows you to retrieve the border style for a border of a given cell.
area is the reference of the Quick Report area.
column is the column number of the cell.
row designates the row number of the cell. You can either:
- pass a positive integer value to designate the corresponding subtotal (break) level that is affected.
- pass one of the following constants of 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 the value that indicates which cell border is 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 |
Note: Unlike the command QR SET BORDERS, QR GET BORDERS does not accept a cumulative value. You must test all the parameters separately to have an overall view of the cell border.
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; it returns the value of the color applied to the line segment.
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.
Product: 4D
Theme: Quick Report
Number:
798
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)
