Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SET FILTER
Message
De
21/12/2000 13:38:22
Ruiz Luiz Alexandre
Set Link Informática Ltda.
São B. Campo, Brésil
 
 
À
21/12/2000 11:23:05
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00455929
Message ID:
00456021
Vues:
25
I have a suggestion uses the commands SQL to bring the result of his/her filter
Ex.:

TABLE: NAMES

FIELDS: NAME, ADDRESS, CITY

SET TO FILTER names.name = "RUSSELL" ---- NOT USED

WITH COMMAND SQL

SELECT name, address, city ...
WHERE name = "Russell"
INTO CURSOR tmpNames

In I begin him/it of his/her ´grid´ puts in ´RecordSource´ the name of the temporary table and it generates in ´load´ it ´select´ with all the data, before doing the filter, and in the moment of selecting ´combobox´ it executes ´select´ again .

Att.: Look commands down.

COMBOBOX1.CLICK


THISFORM.grdMatricula.RecordSource = ""

SELECT ...

THISFORM.grdMatricula.RecordSource = "tmpNames"
THISFORM.Refresh
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform