>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
.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
thisform.mygrid.refresh
Cetin