>Hi all,
>is there any consideration using Navigation button (Top,Previous,Next,Bottom) with Cursoradapter in Multiuser environment ? what happen if someone changes some records and the other one deletes some records in the same table and the same time?
The use of the CursorAdapter really has nothing to do with the funtionality of a navigation toolbar. The changes/deletes of records in a multi-user environment has always been an issue with or without a CursorAdapter. The CA is just a tool to interface with the SOURCE of the data more easily than before. The way we now manage the cursor using the CA is a little different, but once the cursor has been created by the CA, the cursor is still just a cursor like any other local or remote view you ever created in a DBC.
>I have plan to upgrade my native database to cursoradapter based ( the idea ... I can take benefit from using any data sources ), and honestly ... I don't know where to start.
Start by going to
http://www.mctweedle.com and click the FoxTools link. Download the 3 files on CursorAdapters. Two are samples and examples. The third will build a VCX that contains a CA for EVERY table in a database whether it be a DBC, SQL Server or Oracle database. Make sure you read the comments at the beginning of the CA VCX Builder PRG file. This will give you a lot of info about using the builder and the resulting VCX.
Mark McCasland
Midlothian, TX USA