2 column droplist

[Rob Mostyn]

What I have started doing is this:
a. create a method in my table superclass called $addDisplayName
   It sees if the column already exists in the row/list and if not, creates a column called DisplayName char(255)
b. create a method in my table superclass called $displayName
   put in a breakpoint.  You should never reach this code.  It is effectively a private method, hence the breakpoint.
c. in theory each table class for each database table should have a $displayName method.
   In practice only the table classes that use this feature need one.

The $displayName method looks like this:
Calculate $cinst.DisplayName as $cinst.COL1
or
Calculate $cinst.DisplayName as con($cinst.COL1,’, ‘,$cinst.COL2)
or
a sophisticated calculation with conditions based on other columns, ensure display consistency with upp(), cap() etc.

Then in your form/window you simply display the displayName column.

Fetch data code looks something like 
Do llStatus.$fetch_fk(irHeader.primarykey)
While $Loop(llStatus)
   Do llStatus.$displayName()
End while

Rob

> On 9 Sep 2020, at 20:22, Udo Sonnabend | WigaSoft AG <U.Sonnabend at wigasoft.ch> wrote:
> 
> Hi, another suggestion could be to use styled text. U have to set it on in the field properties and than use the style(kescXXX, kTab) function in your concatenation. Take a look into the manuals.... 😉
> 
> My two cents
> Udo.
> 
> WigaSoft AG
> Udo Sonnabend
> Entwickler
> 
> Oberstrasse 222 | Postfach 51 | CH-9014 St. Gallen
> Telefon +41 71 274 51 31 | www.wigasoft.ch<http://www.wigasoft.ch/> | U.Sonnabend at wigasoft.ch<mailto:U.Sonnabend at wigasoft.ch>
> 
> 
> Diese Mitteilung kann persönliche, vertrauliche oder rechtlich geschützte Informationen enthalten und ist nur für die Verwendung durch den beabsichtigten Empfänger bestimmt. Auf Vertraulichkeit oder Rechte wird aufgrund von Fehlübertragungen nicht verzichtet. Wenn Sie nicht der beabsichtigte Empfänger dieser Mitteilung sind, dürfen Sie diese in keiner Form verwenden, verbreiten oder kopieren. Haben Sie diese Mitteilung irrtümlich erhalten, dann löschen Sie diese und allfällige Kopien und benachrichtigen Sie bitte unverzüglich den Absender – besten Dank.
> 
> P Bitte denken Sie an die Umwelt, bevor Sie dieses Mail drucken. Think before print!
> 
> ________________________________
> Von: omnisdev-en <omnisdev-en-bounces at lists.omnis-dev.com> im Auftrag von malkishtini at gmail.com <malkishtini at gmail.com>
> Gesendet: Mittwoch, 9. September 2020 20:06
> An: 'OmnisDev List - English' <omnisdev-en at lists.omnis-dev.com>
> Betreff: RE: 2 column droplist
> 
> Hi Das,
> The way I deal with this case is by concatenating the fields that I want to display in the dropdown list into a single column and then display that column.
> Select (col1 || '  '|| clo2) as column_to_display from...
> You could try this approach.
> 
> HTH,
> Mayada
> -----Original Message-----
> From: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of Das Goravani
> Sent: Wednesday, September 09, 2020 1:42 PM
> To: OmnisDev List - English
> Subject: Re: 2 column droplist
> 
> 
> 
> In my experience which was recent I found that the Forms Droplets is limited to one column.
> 
> I need multiple fields showing so I make a second derivative list at runtime that has multiple things in one field, so it looks like multi column
> 
> Don’t think you can put a data grid into another data grid..
> 
> 
> 
>> On Sep 9, 2020, at 9:46 AM, Louis Kirouac <lkirouac at gmail.com> wrote:
>> 
>> Hi $all
>> 
>> I am using O$ 10.1
>> 
>> Is it possible to display 2 or more columns in a droplist or similar object
>> on a remote form?
>> 
>> The Combobox, Droplist or List Control all seem to be limited to one :(
>> 
>> I want to place a drop list in a Data grid.
>> 
>> Do I have to place a Data grid into another Data grid?
>> 
>> 
>> Louis Kirouac
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com