Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select Records based on Criteria for Grid View
Message
From
09/04/2010 10:52:47
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Select Records based on Criteria for Grid View
Miscellaneous
Thread ID:
01459448
Message ID:
01459448
Views:
93
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
Reply
Map
View

Click here to load this message in the networking platform