Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to use SQL in Grid ?
Message
From
05/10/1998 08:47:38
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
05/10/1998 03:31:14
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00143788
Message ID:
00143829
Views:
23
>In my form design, I have one textbox and one Grid. I want user input the condition for SQL in textbox. And I want my Grid Refresh the SQL condition after the user input the condition in textbox. Please suggest me how do I do ?

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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform