>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.
>ENDCASE
>
>My 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.

Sorry but I'm not familiar with VFX framework.