Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Catégorie:
Codage, syntaxe et commandes
LEN(a_table->fldname) works well for character and memo fields
a more general way of getting the shape and form of any field of a cursor/table out of any free table/dbc would be to use.
ln_fields = AFIELDS(la_array, "a_table")
Where la_array = an array to create with the structure of the table
"a_table" the character representation of the table
ln_fields = number of returned fields in the array
array structure
1 = Field name Character
2 = Field type:
C = Character
D = Date
L = Logical
M = Memo
N = Numeric
F = Float
I = Integer
B = Double
Y = Currency
T = DateTime
G = General Character
3 = Field width Numeric
4 = Decimal places Numeric
5 = Null values allowed Logical
6 = Code page translation not allowed Logical
7 = Field validation expression Character
8 = Field validation text Character
9 = Field default value Character
10 = Table validation expression Character
11 = Table validation text Character
12 = Long table name Character
13 = Insert trigger expression Character
14 = Update trigger expression Character
15 = Delete trigger expression Character
16 = Table comment Character
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement