Hi Sergey,
I have understand better my problem learning the manual of VFX, that is a good Framework but with a poor documentation.
This is the scenario:
1) My app use the Cursor Adapter for the remote Sql database;
2) In a Form I have some Fields, that are created with a PickList Class. The maintenance of this PickList is based on a Picklist Builder.
3) In this Builder I can enter a Select command in order to validate the txtField.
4) The manual suggest a select syntax, example like this:
select customer_id from r_customer where customer_id = trim(this.txtField.Value)5) In my previous app I have used a DBC and the field is a normal textbox; In the Valid event I have enter a condition code, example like this:
DO CASE
CASE table1.Type == 'A' AND (ThisForm.chkbox1.Value OR ThisForm.chkbox2.IvaSospUn.Value) AND table2.Type != '2'
=messagebox (ECL_MSG1,0+16,_screen.caption)
RETURN .F.
CASE table1.Type $ '12' AND ThisForm.chkbox2.Value AND table2.Type != '2'
=messagebox (ECL_MSG2,0+16,_screen.caption)
RETURN .F.
ENDCASEMy answer is this:
"Supposing I have replaced table1 with cursor1 and table2 with cursor2, is possible to create a select that respect the clause at point 5)?"
I hope to have explained better my question.
Best Regards
Nino