Kosta,
You can put the method as a form method, and then call it from a button (or anywhere else on the form). I usually build the code for the SQL statement piece by piece:
cFilter = ''
if !empty(thisform.MyCombo1.value)
cFilter = "MyTable.MyField1 = '" + thisform.MyCombo1.value + "'"
endif
if !empty(thisform.MyCombo2.value)
if !empty(cFilter)
cFilter + " .AND. "
endif
cFilter = cFilter + "MyTable.MyField2 = '" + thisform.MyCombo2.value + "'"
endif
... More additions to cFilter
SELECT * from MyTable1 ;
Where &cFilt ;
into cursor MyCursor
With this code you only add clauses to the filter if they are needed. If a combo or field is empty it is not included.
One further note: In the code above you see that I added quotes around the value of thisform.MyCombo1.value. You need to add this value as a literal value to the string. If you use the "Thisform..." format the value may go out of scope.
HTH
Barbara
>hi Grigore,
>thanks for the help the 2nd problem is OK, I have do it but 1st problem still continiue where to should i create method on the form or on the combo properties
>i dont understand clearly would like to explain me step by step (i am querying my query on the form with combobox and textboxes..)
>
>if youre still online please reply
>
>Kosta