Hi Cetin!
After a long long time i got myself online.
now a days i am working on sql server 2000 and vfp 8.0. i am working on an application for a group of industries. i am working with dataenvironment and cursor adapter. the problem, i am facing is cursorrefresh. bcz i have used dataenvironment and cursor adapter class and u know in cursor adaptor class in the dataaccess tab u have to give select command on which system will get the schema of table. now in select command we have to write statement like this.
select * from customer
now when i refresh the cursor the cursor gets the all records in customer table but now what i want to allow system to give me my desired data whenever i wanted. i mean tell me the way to change the select command of visual class of cursor adaptar on the fly.

waiting for ur quick reply.
take care
bye
atif saeed khan.
software developer.
real time technology.
www.realtime-dxb.com