About the extended attribute system tables  Edit style types for the PBCatEdt table

Appendix A: Extended Attribute System Tables

The extended attribute system tables

This section lists and describes all of the columns in each of the extended attribute system tables.

NoteNot all columns apply to PocketBuilder applications Some of these columns contain information that does not apply to PocketBuilder. The columns were assigned originally for PowerBuilder applications.

Table A-2: The PBCatTbl table

Column

Column name

Description

1

pbt_tnam

Table name

2

pbt_tid

Adaptive Server Enterprise Object ID of table (used for Adaptive Server Enterprise only)

3

pbt_ownr

Table owner

4

pbd_fhgt

Data font height, PowerBuilder units

5

pbd_fwgt

Data font stroke weight (400=Normal, 700=Bold)

6

pbd_fitl

Data font Italic (Y=Yes, N=No)

7

pbd_funl

Data font Underline (Y=Yes, N=No)

8

pbd_fchr

Data font character set (0=ANSI, 2=Symbol, 255=OEM)

9

pbd_fptc

Data font pitch and family (see note)

10

pbd_ffce

Data font typeface

11

pbh_fhgt

Headings font height, PowerBuilder units

12

pbh_fwgt

Headings font stroke weight (400=Normal, 700=Bold)

13

pbh_fitl

Headings font Italic (Y=Yes, N=No)

14

pbh_funl

Headings font Underline (Y=Yes, N=No)

15

pbh_fchr

Headings font character set (0=ANSI, 2=Symbol, 255=OEM)

16

pbh_fptc

Headings font pitch and family (see note)

17

pbh_ffce

Headings font typeface

18

pbl_fhgt

Labels font height, PowerBuilder units

19

pbl_fwgt

Labels font stroke weight (400=Normal, 700=Bold)

20

pbl_fitl

Labels font Italic (Y=Yes, N=No)

21

pbl_funl

Labels font Underline (Y=Yes, N=No)

22

pbl_fchr

Labels font character set (0=ANSI, 2=Symbol, 255=OEM)

23

pbl_fptc

Labels font pitch and family (see note)

24

pbl_ffce

Labels font typeface

25

pbt_cmnt

Table comments

NoteAbout font pitch and family Font pitch and family is a number obtained by adding together two constants:

Table A-3: The PBCatCol table

Column

Column name

Description

1

pbc_tnam

Table name

2

pbc_tid

Adaptive Server Enterprise Object ID of table (used for Adaptive Server Enterprise only)

3

pbc_ownr

Table owner

4

pbc_cnam

Column name

5

pbc_cid

Adaptive Server Enterprise Column ID (used for Adaptive Server Enterprise only)

6

pbc_labl

Label

7

pbc_lpos

Label position (23=Left, 24=Right)

8

pbc_hdr

Heading

9

pbc_hpos

Heading position (23=Left, 24=Right, 25=Center)

10

pbc_jtfy

Justification (23=Left, 24=Right)

11

pbc_mask

Display format name

12

pbc_case

Case (26=Actual, 27=UPPER, 28=lower)

13

pbc_hght

Column height, PowerBuilder units

14

pbc_wdth

Column width, PowerBuilder units

15

pbc_ptrn

Validation rule name

16

pbc_bmap

Bitmap/picture (Y=Yes, N=No)

17

pbc_init

Initial value

18

pbc_cmnt

Column comments

19

pbc_edit

Edit style name

20

pbc_tag

(Reserved)
Table A-4: The PBCatFmt table

Column

Column name

Description

1

pbf_name

Display format name

2

pbf_frmt

Display format

3

pbf_type

Data type to which format applies

4

pbf_cntr

Concurrent-usage flag
Table A-5: The PBCatVld table

Column

Column name

Description

1

pbv_name

Validation rule name

2

pbv_vald

Validation rule

3

pbv_type

Data type to which validation rule applies

4

pbv_cntr

Concurrent-usage flag

5

pbv_msg

Validation error message
Table A-6: The PBCatEdt table

Column

Column name

Description

1

pbe_name

Edit style name

2

pbe_edit

Format string (edit style type dependent; see “Edit style types for the PBCatEdt table”)

3

pbe_type

Edit style type

4

pbe_cntr

Revision counter (increments each time edit style is altered)

5

pbe_seqn

Row sequence number for edit types requiring more than one row in PBCatEdt table

6

pbe_flag

Edit style flag (edit style type dependent)

7

pbe_work

Extra field (edit style type dependent)



Copyright © 2004. Sybase Inc. All rights reserved. Edit style types for the PBCatEdt table

View this book as PDF