Hi

I need to display the structure of a table by reading its structure

How can this be achieved and displayed say in a say a stringlist or listbox
I have tried the documentation but it is not so easy / obvious what i need to do to achieve the result.


Kind regards


Kamran

See my answer to your other post.

For structure you can either use fielddefs (better way) or as long as
you have a single record just use the same logic as i did in other post.
Simply loop once thru fields and look for myDS.Fields[I].DisplayName,
myDs.Fields[I].DataType, etc). Looping thru fielddefs is very similar as
well.

Raul

On 8/7/2013 5:07 PM, kamran wrote:
> Hi
>
> I need to display the structure of a table by reading its structure
>
> How can this be achieved and displayed say in a say a stringlist or listbox
> I have tried the documentation but it is not so easy / obvious what i need to do to achieve the result.
>
>
> Kind regards
>
>
> Kamran
>

Thanks Raul - that's a great help

Kamran


Raul wrote:

See my answer to your other post.

For structure you can either use fielddefs (better way) or as long as
you have a single record just use the same logic as i did in other post.
Simply loop once thru fields and look for myDS.Fields[I].DisplayName,
myDs.Fields[I].DataType, etc). Looping thru fielddefs is very similar as
well.

Raul

On 8/7/2013 5:07 PM, kamran wrote:
> Hi
>
> I need to display the structure of a table by reading its structure
>
> How can this be achieved and displayed say in a say a stringlist or listbox
> I have tried the documentation but it is not so easy / obvious what i need to do to achieve the result.
>
>
> Kind regards
>
>
> Kamran
>