Re: listbox property "bound field" in gridcontrol
"Frank Schoenheit, Sun Microsystems Germany" <[email protected]> Mon, 11 Jan 2010 11:53:17 +0100
| Newsgroups | gmane.comp.openoffice.dba.user |
|---|---|
| Message-ID | <[email protected]> |
Hi Peter, > there are at least two ways to show data from another table in a > gridcontrol: either a table or a select statement. > > Assuming the first column in the other table is an id (foreign key in my > gridcontrol table), the second column is the value I want to show in the > gridcontrol: > > Is it the correct that: > > * this is not possible with using a table, whatever value is set to > the property bound field. > The table shows always the value of the first column. > * this is only possible with a select statement, if the the first > column is specified as that one I want to see in my gridcontrol. that's correct. That's one of the history quirks of the list box - the "display column" is always the first column of the result set which is used to fill the list. Ciao Frank -- - Frank Schönheit, Software Engineer [email protected] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -