Simple answer is that it Cannot. A single CA can have only one data Source Type - ODBC, ADO or NATIVE (for now). So a select like yours will not work.

But you can use the CA's to retreive your dataset from SQLServer, and another from Native VFP data, THEN issue your select statement to produce your new cursor. This can be done in the AfterCursorFill method (most convenient). You can also create Indexe's for your cursor's here.


CA's are as yet a relatively unexplored area.

>Hi....
>
>Starting to move my system to vfp 8/9
>
>My first question is can a cursor adaptor connect to VFP Data and SQL-Server data at the same time..
>
>something like the below
>
>Select a.*, b.* from vfpdata a inner join sqlserverdata b on(a.iid = b.iid) where b.customer = 'First Last Bank'
>
>just an example above but you get the idea
>
>I'm guessing it can ;) but haven't a clue as to how
>
>
>I'll have many more questions but this should get me started
>
>
>jp