Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ListBox Loading Slow
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00608008
Message ID:
00608054
Vues:
25
Hello Kevin.

My code to load the list now looks like:

SELECT TRANSFORM(Id) AS Id,;
  StatName,;
  ProgTitl,;
  ClientId,;
  BkPhone,;
  DTOC(BkDate) + " " + BkTime AS DateTime,;
  TRANSFORM(BasOrdr) AS OrdQty,;
  State;
 FROM Resh;
 WHERE ALLTRIM(ClientId) = "GM";
 INTO ARRAY aResults

=ACOPY(aResults, .aResults)

.Refresh()


You need to issue a combo.Requery() after you populate it. But you can make it load even faster by using a RowSourceType of 6-Fields and setting up its RowSource like this:

Resh.Id, StatName, ProgTitl, ClientId, BkPhone, BkDate, BkTime, BasOrdr, Stat

Some special reason you aren't doing it like this?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform