>>>Hi,
>>>
>>>When I modify structure in the VFP IDE I can see for some fields in the table, the value in the field Display Library. Since all my tables are in a DB container, is it possible to select from all tables in the container that have a value in this field (Display Library)? Or select all field where the value in Display Library contains a key word (e.g. "XYZ")?
>>>
>>>TIA
>>
>>Hi, Dmitry
>>
>>It seems that the signature for the Display library in the Property field is 0h010033, so to get all the fields and then their tables...
>>
>
>Antonio, (or anyone else who could educate me, please).
>You said "signature 0h010033". What does it mean?
>And then in your code when you STREXTRACT, you use [CHR(1) + CHR(0) + "3"]. How does it "relates" to "0h010033"?
>
>Thank you.

The database container is a table, as you know. What it holds is information regarding all of the database objects, a row per object (the database itself, tables, views, connections, and so on).

Most of the time, the information is stored in the Property column, but since the possibilities may be quite diverse (fields, for instance, have the display library attribute you're looking for, but also other information, such as input mask, or caption, or...), each of the object's property is identified by a signature.

The Display Library (seems to) have the 0h010033 signature, which is hexadecimal for CHR(1) + CHR(0) + "3".

In fact,

? 0h010033 == CHR(1) + CHR(0) + "3"

holds .T., so the expression could be rewritten as

STREXTRACT(Property, 0h010033, 0h00)