[Gambas-user] DataBrowser

[Mathias Ebermann]

No, Charlie,
I didn't mean the headers. I know how to rename them.

What I meant is:
In my DataSource table I have a field "ProducerID".
That points to another table "Producers" with the key field "id" and the field "Name".
Now I would like to have the Column "Producers.Name" in the list instead of "ProducerID".
I mean the field values of the records, not the headers.


Charlie Reinl schrieb:
> Am Montag, den 31.08.2009, 21:52 +0200 schrieb Mathias Ebermann:
>> Hi,
>>
>> DataBrowser is a really great tool.You don't need any code for displaying the fields of records, depending on what the user
>> clicks in the GridView..
>>
>> But since DataBrowser uses only ONE table (set in DataSource), I can't find a way to display for example "Producer.Name" in
>> the GridView instead of "ProducerID".
>>
>> Is there any possibility to show a reference to another table in the DataBrowser.GridView?
>>
>> Thannks for help
>> Matti
> 
> Salut Mathias,
> 
> this is out of examples/Database/FTest if you mean the headers text
> 
> PUBLIC SUB Form_Open()
> 
>   WITH DataBrowser2.GridView
>     .Columns[0].Text = "Color"
>   END WITH
>   
>   WITH DataBrowser1.GridView
>     .Columns[0].Text = "Id"
>     .Columns[0].Width = 48
>     .Columns[1].Text = "Active"
>     .Columns[2].Text = "Name"
>     .Columns[3].Text = "Firstname"
>     .Columns[4].Text = "Birthday"
>   END WITH
>   
> END
> 
>