Solved

Delphi / Firemonkey Combo Box values, possable?

Posted on 2014-01-21
11
4,000 Views
Last Modified: 2014-06-02
Hi,

I want to have a selected value that is different than the displayed value?

It is possible to do this in HTML and in .net.

Is it possible to do this in Delphi/FireMonkey Mobile?

When I go into the ComboBox Items Designer it only shows a place to enter the display text.

Likewise in the Object Inspector, the Combo Box items look more like ListView items with text only, no values.

My desire is to have unique values for the displayed items that can be stored in a DB table and used against a lookup table.

I would also like to have the combo items populated form that same lookup table, but I don't see any way to do that with Live Bindings.

Gary
0
Comment
Question by:Gary4
  • 6
  • 5
11 Comments
 
LVL 26

Accepted Solution

by:
Sinisa Vuk earned 500 total points
ID: 39798609
You can use livebinding...
http://edn.embarcadero.com/article/41708
But there is a problem that binding use just 200 items.

I prefer custom filling (binding do same internally).
This can be don in Delphi/FireMonkey too.
  ComboBox1.Items.Clear;

  ADODataSet1.First;
  while not ADODataSet1.Eof do
  begin
    ComboBox1.Items.AddObject(
      ADODataSet1.FieldByName('ItemName').AsString,
      TObject(ADODataSet1.FieldByName('ItemId').AsInteger)
      );

    ADODataSet1.Next;
  end;

Open in new window


... selected item id you can get as:
if Assigned(ComboBox1.Selected) then
    ShowMessage(IntToStr(Integer(ComboBox1.Selected.Data)));

Open in new window


my dataset is looking ...
select ItemName,Itemid from mytable order by 1

Open in new window



As I can see live binding is more a problem than a solution.
0
 
LVL 1

Author Closing Comment

by:Gary4
ID: 39801251
I found an article that told how to do it with Live Bindings and I did it that way.  I wasn't' particularly intuitive because of the field names used.

However, your code did help me with some other issues I had.
0
 
LVL 1

Author Comment

by:Gary4
ID: 40104306
@Sinisa Vuk

Hi,

I came back to this for the same problem on another project.  This time I used your solution since I couldn't use Live Bindings this time.

I wish I could give you 500 more points and up the rating!
0
 
LVL 26

Expert Comment

by:Sinisa Vuk
ID: 40104356
Glad that my comment helps ....
0
 
LVL 1

Author Comment

by:Gary4
ID: 40104457
Hi,

Sorry to be a pest, however,

There seems to be a problem in my code.

This code is in a data module.  The control is passed in from a from.  The control is on the form.

InterestTB  is a FireDac FDTable on the data module.

procedure TChirpMaxDB.FillddChannel(ddChannel: TComboBox);
var
  I: Integer;
  sb: string;
begin
  ddChannel.BeginUpdate;
  ddChannel.Items.Clear;
  with InterestTB do
  Begin
    Active := True;
    First;
    while (not Eof) do
    begin
      I := FieldByName('ID').AsInteger;
      sb := FieldByName('Name').AsString;
      ddChannel.Items.AddObject(sb, TObject(I)); // <-- It fails on this line on the first iteration.
      Next;
    End;
    Active := False;
  End;
  ddChannel.ItemIndex := 0;
  ddChannel.EndUpdate;
  ddChannel.Repaint;
end;

Open in new window


Any thoughts?

The code ran fine with win32 as the target.

It's failing with Android as the target.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 26

Expert Comment

by:Sinisa Vuk
ID: 40104945
Why don't you say - android? :-)

Unfortunately, .AddObject doesn't work on android/ios. Had same problem too.
Read this on this blog and how to overcome this:
http://blogs.riversoftavg.com/index.php/2013/08/01/using-primitive-types-with-tstrings-in-ios/
0
 
LVL 1

Author Comment

by:Gary4
ID: 40105206
I did say Firemonkey, implying cross platform. :-)

One would think they would throw a compile error rather then leaving it laying around to trip over like some scripting language.

The again, one would think if they knew about it they would 'make' it work like they did other things.

I spent about ten years with .net and never thought twice about 'boxing', except as a possible performance penalty.

Thanks again :-)

I think this is now my go to place for Delphi/Firemonkey help.
0
 
LVL 26

Expert Comment

by:Sinisa Vuk
ID: 40105246
No problem. As I'm sw developer with full time job (using Delphi), sometimes I come to problems before others :-)
0
 
LVL 1

Author Comment

by:Gary4
ID: 40105263
I'm a full time developer too, I find it objectionable to stumble over problems in my development tools.

In this case the compiler is generating bad code and if storing an integer as an object is not part of the language it should have thrown an error.

I spent 12 hours futzing with this.  Time I should have spent making a TEdit scroll.

Are you part of the hire-a-pro thing they recently announced?
0
 
LVL 26

Expert Comment

by:Sinisa Vuk
ID: 40105276
No, maybe will be in future :-) couse I'm short with time these days....
0
 
LVL 1

Author Comment

by:Gary4
ID: 40105294
Fair enough.  I was only thinking of short term things that stump me. Maybe of a day or less. I didn't have anything in mind right now.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now