robsuttonjr
MIS
Can anyone tell me if using the cursor adapter vs. remote view is better and why? I am taking over development of an application using remote views but want to make sure I am using the best possible data layer available.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Cursor adapter vs. remote view 1
- Thread starter robsuttonjr
- Start date
- Status
HI
Cursoradapters suport handling wide range of data sources as native Visual FoxPro cursors. These data source types can be .. VFP, ODBC, ADO, XML etc.
So new developments should benefit if Cursoradapters are used.
You can develop cusoradapter class and inherit the class which will help faster and simpler development.
ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com
Cursoradapters suport handling wide range of data sources as native Visual FoxPro cursors. These data source types can be .. VFP, ODBC, ADO, XML etc.
So new developments should benefit if Cursoradapters are used.
You can develop cusoradapter class and inherit the class which will help faster and simpler development.
ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com
- Thread starter
- #3
robsuttonjr
MIS
Are there any reliability benefits of using the cursor adapter over remote views? I don't want to rewrite the program using remote views based on more flexibility. I would only consider rewriting if the cursor adapter is more stable, handles drop of network connection better, etc. Also does the cursor adapter handle updating any changes that may have occurred since the user opened the view? Thanks
-
1
- #4
The CursorAdapter can handle Stored Procedures, which you can't do with a Remote View. It can also use OLE DB for connecting to the server, which is faster and consumes fewer resources that ODBC.
Craig Berntson
MCSD, Visual FoxPro MVP, Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"
Craig Berntson
MCSD, Visual FoxPro MVP, Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"
Mike Lewis
Programmer
Rob,
I'm not sure about reliability or performance, but the cursor adapter has the benefit of being sub-classable, which can be a big advantage if you are writing generic data-handling classes.
Mike
Mike Lewis
Edinburgh, Scotland
I'm not sure about reliability or performance, but the cursor adapter has the benefit of being sub-classable, which can be a big advantage if you are writing generic data-handling classes.
Mike
Mike Lewis
Edinburgh, Scotland
Mike Lewis
Programmer
Remsor,
Is there anyway to use the cursor adapter with out using or upgrade from vfp6 to vfp8.
Can't see how. Cursor adapters were a new feature in 8.0.
Mike
Mike Lewis
Edinburgh, Scotland
Is there anyway to use the cursor adapter with out using or upgrade from vfp6 to vfp8.
Can't see how. Cursor adapters were a new feature in 8.0.
Mike
Mike Lewis
Edinburgh, Scotland
- Status
