Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can we input Query in Grid
Message
From
07/01/1999 23:33:52
 
 
To
07/01/1999 21:55:51
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00173900
Message ID:
00173910
Views:
18
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform