Can you construct a "unique key" from concatenated fields, if so then you should be OK. also I would like to experiment with recno() as a field in the cursor sort of like:

create sql view myview as ;
  select *, rec_no as recno('mydostable') from mydostable

And then use rec_no as the unique key, I would need some experimenting with this technique. You might want to give it a try.
>Hi Glenn,
>
>I have been making plans to proceed with your suggested solution. I have a potential problem. Back in the old fpw2.6 days, I did not include a unique identifier field in my data tables ie: cID or iID.
>Will this be a problem if I am attempting to hook into my fpw2.6 tables via updatable, parameterized views?
>
>Neil
>
>
>>I do not see any particular problem, give it a try. In fact, after reviewing my notes, I am not sure you cannot use alter table either. I will try it with some old FP2.5 stuff I got on my system.
>>
>>Glenn
>>
>>>Now that sounds like what I am looking for. May I use an exisiting dbc in my vfp project that contains many tables and views and just add views of the free fpw2.6 tables. I use sdt to maintain my dbc.
>>>
>>>Neil
>>>
>>>
>>>>Of course you can use/read/write to FP2.6 tables from VFP. It is safe and consistant with backward compatability. SQL views are only maintaiuned in a Database Container and therefore the tables cannot be contained in the DBC. It is possible to create a DataBase with nothing but views. These views could be based upon free tables (FP2.6). I did this once 5 years ago while integrating VFP with FP2.5.
>>>>
>>>>On caveat however is DO NOT alter table with VFP on a FP2.6 table. AFAIK this will modify the header to make the table unusable by FP2.x
>>>>
>>>>Glenn
>>>>
>>>>>Hi,
>>>>>
>>>>>I have a legacy FPW 2.6 application that maintains 19 tables. Is there a way to have a multi threaded vfp 7 dll read and write the fpw tables while the tables are also being read and write by the fpw 2.6 exe. What tricks can I perform that allows me to create views of the fpw2.6 tables.
>>>>>
>>>>>Neil