Hi again John,

>Hiya Ji
So, to be clear, the actual SQL is *executed* by other than VFP. So we do *not* get the advantage of VFP's native SPEED - its major selling point along with flexibility.

Couldn't this just as easliy be done in VB?? Wouldn't it be just about as fast? Where is the ADVANTAGE for VFP.

Cheers,

Jim N

m ---
>
>Maybe a terminology difference? :-)
>
>A successful VFP data brokering middle-tier might expose a method called ..ohhh.....MemberStateCount to show the number of members in a given state. So, you could called it from VB with MemberStateCount("FL") and get back the number for Florida PDQ as VFP would execute the SQL statement to derive the value and send it back.