4D v14.3

QR SET BORDERS

Home

 
4D v14.3
QR SET BORDERS

QR SET BORDERS 


 

QR SET BORDERS ( area ; column ; row ; border ; line {; color} ) 
Parameter Type   Description
area  Longint in Reference of the area
column  Longint in Column number
row  Longint in Row number
border  Longint in Border composite value
line  Longint in Line thickness
color  Longint in 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.

 
PROPERTIES 

Product: 4D
Theme: Quick Report
Number: 797

This command modifies the Error system variable

 
HISTORY 

Created: 4D 2003

 
SEE ALSO 

QR GET BORDERS

 
ARTICLE USAGE

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)