Very Computer

Hello everybody.

Could a kind soul tell me how I retrieve fieldstructure information by
code.
DBUtil32 and similar tools do not have a Purpose field, which I want to use
as a reminder for the fields purpose later on when I have forgotten all
about it. So I made a table in which I put field structure information, and
purpose information for the original table. Its tedious work to manually
write records with fields information. I use dBase tables. I need to know
the syntax of code that automatically fills my table with field structure
information from another table. (Fields name, type, size just like DBUtil32
does) Then I only have to fill in the purpose for the fields later on.
Could this be done by simple code?

I think most of the information you need are in the TTable.FieldDefs-Array.

--
Andreas Klein

Kai Inge Buseth schrieb in Nachricht

Quote:>Hello everybody.

>Could a kind soul tell me how I retrieve fieldstructure information by
>code.
>DBUtil32 and similar tools do not have a Purpose field, which I want to use
>as a reminder for the fields purpose later on when I have forgotten all
>about it. So I made a table in which I put field structure information, and
>purpose information for the original table. Its tedious work to manually
>write records with fields information. I use dBase tables. I need to know
>the syntax of code that automatically fills my table with field structure
>information from another table. (Fields name, type, size just like DBUtil32
>does) Then I only have to fill in the purpose for the fields later on.
>Could this be done by simple code?

>Thanks in advance for all help.
>--
>Regards
>Kai Inge

Hi Kai,
there are 2 BDE procs for retrieving field structure info (have a look at
BDE help):
DbiGetFieldDescs
DbiOpenFieldList

If you're using RX-lib, it should be easy:
take a TTableItems with dtFields as ItemType (which gives you a table
containing all fieldinfo)
and a batchmove to copy the info to your table

Hope this helps
Dieter
--
if you want to email me please remove .xxx