>We are about to convert our current C/S Hospital System to VFP8.0 because of CursorAdapter promises. But my boss is quite apprehensive on its stability. His premise is that while RVs and SPTs have limitations in many ways including its maintenance issues, we can live to it for now. Is CursorAdapter really more reliable that RV and SPT?
IMO, yes if used properly. They are indeed a RV killer. Technically speaking, the CA is still using SPT to send SQL commands to the database. However, with the CA, you now have more control and a better interface to your data than you do with RVs. With properties like ConversionFunc, you no longer have issues with RPADded data being sent back to your VARCHAR fields. You can use CursorSchema to better define what the structure should be of the returned cursor - forcing datetime fields in a SQL DB to be date data types in the return cursor is nice and is a frequent question in NGs.
Mark McCasland
Midlothian, TX USA