I know this is off this topic.........

Have you had any luck with RDS and VFP data? I have noticed most of your papers and Devcon Sessions deal with ADO only. I am starting an order entry Intranet/Extranet app and would like your opinion of RDS. Or if there is a better solution than RDS.

RDS seems easy to implement, but I have not had any luck with it yet....Keep getting "Internet Server Error" when I try to use my own business object instead of the default RDS business object.

>The issue you are dealing with stems from the fact that your recordset does not have a key that uniquely identifies a record. I published a tip about this 2 or 3 years ago in FoxTalk. If you create a local view/remote view in which the field specified as the key is not unique, changes made to 1 record with that key will propogate to all records with that key value.
>
>This issue has nothing to do with bookmarks. In fact, if your cursortype is set to static (3), bookmarks are in fact supported.
>
>The solution, make sure you both have a primary key in your tables, and for the table you wish to update, make sure that key is included in your ADO Recordset.
>
>
>>John Hi,
>>
>>Here is another problem with ADO using VFP DBF's.
>>
>>I execute an Rs.Open "SELECT " statement and get a record set.
>>
>>I then update most fields only one record from that recordest and perform an Rs.Update.
>>
>>If the record set happens to contain more than one record that are exactly the same (for example all fields are blank), then all the records are updated and thereby I get duplicates in the table even though my intention was to change only one record.
>>
>>I believe that this may have something to do with the fact that the OLE-DB provider (in this case MS VFP) does not support bookmarks (or record numbers in this case).
>>
>>Am I correct in this assesment and is there a workaround?
>>
>>Thanks
>>
>>Costas