Dismiss Notice

REGISTRATION IS AFTER ADMIN ACTIVATION

DONATIONS WITH PAYPAL CLICK TO BUTTON

1 MONTH VIP - 5$; 3 MONTHS VIP - 10$; 6 MONTHS VIP - 20$; 1 YEAR VIP - 30$; 2 YEARS VIP - 50$; GOLD USER FOR LIFE VIP - 150$

DONATIONS WITH Bitcoin Address:3NRs3CK3fhXifrNYxHEZKpETDd9vNLMsMD

Dismiss Notice
The registration is approved by the Administrator. It takes about 1 day to approve your registration
Dismiss Notice
For open hidden message no need write thanks, thank etc. Enough is click to like button on right side of thread.

[IOS] HELP ME - Slow populate combobox on query sqlite

Discussion in 'Delphi Android And IOS' started by pumidru, Apr 23, 2014.

  1. pumidru
    Online

    pumidru DF Junior

    Help me, slow populate combobox

    To extract 50 rows of 8100 takes 20 seconds,on iPhone 4S (not simulator)

    This code is correct?

    Is there a quick way to fill a combobox  with data query?

    Code:
      ObjQry := TFDQuery.Create(nil);
      ObjQry.Connection := FDConn;
    
      ObjQry.SQL.Clear;
      ObjQry.SQL.Add('SELECT DISTINCT Prov FROM DATI  ORDER BY Prov ');
    
      try
         ObjQry.Open;
      except
        ShowMessage('not open query select Prov');
      end;
    
      ObjQry.First;
      if ObjQry.RecordCount > 0 then
      begin
        Prov.Items.Clear;
        while not ObjQry.Eof do
        begin
          Prov.Items.Add(ObjQry.FieldByName('Prov').AsString);
          ObjQry.Next;
        end;
        Prov.ItemIndex := 0;
    
      end;
     ObjQry.Close;
    

    Thanks
     
  2. N0body
    Online

    N0bodyN0body is a Verified Member DelphiFan Administrator Staff Member DF Staff

    RE: [IOS] HELP ME - Slow pppulate combobox on query sqlite

    1.  can you use dblookupcomboox? This is very good for you.
    ------------------------------------------------------------------

    2. You can use Tstringlist with visible false :D after this you can put valuest to string list and 

    ComboBox.Items.Assign(stringlist);
    -------------------------------------------------------------------
    3. You can user Getrows with this code


    Code:
    var
      V: Variant;
      I: Integer;
    begin
      V := ADOQuery1.Recordset.GetRows(adGetRowsRest, EmptyParam, 'ColumnName');
    
      for I:= VarArrayLowBound(V, 2) to VarArrayHighBound(V, 2) do
        ComboBox1.Items.Add(V[0, I]));
    end;
    
    
     
  3. pumidru
    Online

    pumidru DF Junior

    RE: [IOS] HELP ME - Slow pppulate combobox on query sqlite

    AdoQuery not compatible with IOS.

    use:
    V:= ObjQry.GetRow(adGetRowsRest, EmptyParam, 'ColumnName');

    Error

    function TFDDataSet.GetRow(ABuffer: TRecBuf = C_NIL;
      AForceBufferRead: Boolean = False): TFDDatSRow;


    Please post FireDac sampler.

    Thanks
     

Share This Page

Laws
Our website, law, laws, copyright and aims to be respectful of individual rights. Our site, as defined in the law of 5651 serves as a provider of space. According to the law, contrary to the law of site management has no obligation to monitor content. Therefore, our site has adopted the principle of fit and remove. Works are subject to copyright laws and is shared in a manner that violated their legal rights, or professional associations, rights holders who, adsdelphi@gmail.com I can reach us at e-mail address. Complaints considered to be infringing on the examination of the content will be removed from our site.
Donate Help To Us and Be VIP
DONATIONS WITH PAYPAL CLICK TO BUTTON
6 MONTHS VIP - 20$; 1 YEAR VIP - 30$; 2 YEARS VIP - 50$; GOLD USER FOR LIFE VIP - 150$
Social Block