Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select Records based on Criteria for Grid View
Message
De
09/04/2010 10:52:47
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Select Records based on Criteria for Grid View
Divers
Thread ID:
01459448
Message ID:
01459448
Vues:
94
hELLO All

i have this code in the init of my form
select sum(p1),sum(p2),sum(p3);
from bank
where id='E' and clientid=apprid into table exp

select bank
set filter to bank.itemtype='E' and bank.clientid=apprid
go top
and here is the code on my view
select * ;
from mainbase!bank;
where bank.id=("E");
and bank.clientid=(apprid)
So i have this table named bank and i select what i want based on the ID of the client an the Item type which has to be E.
but with set filter clause when i dont add the "and bank.clientid=apprid part the form doesnt go in editing mode when it should
as in. My form doent execute the class mode too go in enabled mode
Répondre
Fil
Voir

Click here to load this message in the networking platform