>We would like to display Table's information (such as customer information) in Grid by using Sele .... cammand (eg. Sele customer.name, customer.add1,.....where customer.state = Thisform.txtbox1.value)which controled condition by textbox. Where 's Sele.... command must store ?
> Thanks for your time.
If the wuery only needs to run once, you can run the query in the form's load event like this:
SELE customer.* (whatever);
INTO CURSOR myCursor
THISFORM.mygrid.REcordSourceType = 6 &&alias
THISFORm.mygrid.Recordsource = "mycursor"
Erik Moore
Clientelligence