Yes, I remember the old days in VB. It was very simple, when you used the result of a SQL query as DataSource.
I will install Gambas3. Thanks. Benoît Minisini schrieb: >>> 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. >> In Gambas 3, the Table property of a DataSource can be any SQL request. >> >> In Gambas 2, I'm afraid there is no simple solution. But try this: use your >> own DataView control, and create an Observer on the GridView of the >> DataView control - you get it with the DataView.GridView property. Then >> catch the Data event with the Observer: by using the Row property, you will > . > /|\ > | > Read 'Column' instead -----------------------------------' > >> know if you are in the ProducerID column, and then you can replace the >> displayed data with the name of the producer by setting the >> GridView.Data.Text property. >> >> Regards, > > > ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user