1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Donation with Paypal!!!

    Go to your paypal account and send directly donation to [email protected]

    1 month - 10 $ - Standart VIP

    6 months - 20 $- Standart VIP

    1 year - 30 $- Standart VIP

    2 years - 50 $- Standart VIP

    Gold member for life - 150 $- Standart VIP

    High Vip (Standart VIP include) group please send PM or email to [email protected] for info

    After Donation please send email to [email protected]

  3. Donation Ways 2020


    Paysend
  4. Telegram

  5. Delphifan Magazine
Dismiss Notice

Donation with Paypal!!!

Go to your paypal account and send directly donation to [email protected]

1 month - 10 $ - Standart VIP

6 months - 20 $- Standart VIP

1 year - 30 $- Standart VIP

2 years - 50 $- Standart VIP

Gold member for life - 150 $- Standart VIP

High Vip (Standart VIP include) group please send PM or email to [email protected] for info

After Donation please send email to [email protected]

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. AdminDF
    Online

    AdminDFAdminDF is a Verified Member Delphifan 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