Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to use SQL in Grid ?
Message
From
06/10/1998 00:32:34
 
 
To
05/10/1998 08:47:38
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00143788
Message ID:
00144114
Views:
22
>Suppose you have 3 textboxes (you have one) as txt1, txt2, txt3 referring to fields fld1, fld2, fld3 in your SQL :
Grid.init
>with this
>  .recordsourcetype = 4 && SQL
>  .recordsource = "select * from mytable "+;
>     "where fld1 = trim(thisform.txt1.value) " +;
>     "and fld2 = trim(thisform.txt2.value) " +;
>     "and fld3 = trim(thisform.txt3.value) " +;
>     "into cursor grdCursor"
>endwith
>
>* Lostfocus of textboxes
>thisform.mygrid.refresh
Cetin


Thanks for your suggestion. But I mean that I have set txtbox for my SQL condition. Example , if user input date=05/15/98 in txt1 . I would like my Grid refresh : Sele * from ...... where date >= txt1. Where I must store SQL command. At now I have store in form.load but it not effect my Grid.
Thanks again.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform