Hi John

>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


You can have many cursoradapter opened at the same time with different data source each. But you can't load data from different sources at the same time. In your example, you can create an A cursor with data from VFP, and a B cursor with data from SQL Server if your customer is in the cursor B you can filter ex: SQLCmnd in cursor B would be: select * from mysqlservertable b where b.customer = 'First Last Bank'

Now you have a cursor A and B from different sources and you can create a local cursor with a select command : Select a.*, b.* from vfpdata a inner join sqlserverdata b on(a.iid = b.iid).

The other way, as say Aleksey, is create a new class with tree cursors that do same thing.

Regards,

Carlos