While I use Visual Extend, I didn't use the most recent versions, so I can't help specifically with cursor adapters. I suggest you post the question in the Visual Extend forum.
>Hi to all,
>
>I need a little help about a "where clause".
>In a form I use only one SQL table, i.e named cTable.
>
>I have created two CA,i.e named caTable1 and caTable2, with the same Select like this:
>Select cTable.code, cTable.descr, cTable.perc1, cTable.perc2, cTable.appcode from cTable
>
>The cursor caTable2 is used in the form in order to create a PickList for Field appcode in cTable.
>
>I need to create in the caTable2 a "where" clause that satisfy these rules when appcode in the Form is not null:
>1) The perc1 in the caTable2 must be equal to perc1 in caTable1
>2) the perc2 in the catable1 must be equal to ZERO.
>
>I am a neophite in VFP with SQL, and I hope in your help in order to resolve this question.
>
>Thank you and Best Regards.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
