Juraj Trenkler wrote:
Dn(a Thursday 04 October 2007 Girvin R. Herr napísal:
My question to the developers is: when is this feature to be implemented
in Base?
I can't believe I am not the only user who has a need for this feature.
Any information on this will be appreciated.
BTW: Rekall does implement this feature, although it is not well
documented and Rekall does not seem to allow adjusting the column
widths. However, the data is visible to aid selection from the list.
Maybe something like "SELECT concat(field1, field2), field2 FROM table1 could"
help you.
Put this it in list box properties as can be seen on attached picture.
juraj
Hi Juraj,
There are some issues here with the current way to handle this - as you
show using SQL to form a compound string for display.
First - there is the issue of usability. Not supporting multiple columns
raises the threshold for users.
For example if multi-column support existed within the control then a
user could take advantage of it simply by using the GUI query designer,
with out any need to enter text of any kind. But by not supporting it
then even the simplest use case because reason to have to 'code'. Your
example is a great one for this
SELECT CONCAT( "col1", "col2" ) from "Table"
Chances are that that would be unacceptable in practice. Lets say it as
simple a First Name , Last Name do you really think the user wants to see
JohnSmith
Of course not, they want John Smith so the simplest case now becomes
SELECT CONCAT( "Col1", CONCAT( ' ', "Col2") FROM "Table2"
and we haven't even dealt with 'null fields' and alignment issues when
there is more then 2 columns yet
Now for the killer - that works for list boxes ( if we added in that
forgotten Id type field in the example above ) but if this is for a
combo box, nope doesn't work at all.
For a combo box you end up having to build an event handler for the
status change event ( user selected an item ) and then parse the string
to find the value that you wanted to put into the column of the target
table.
So, can you simulate multiple columns support now - YES you can, but
there is a whole class of end user for whom the answer to that question
in reality is NO.
Drew
