>>>Does anyone else have additional points to add?
>>>
>>>Mark McCaslands message is useful on this Message #733636
>>
>>In addition to that, if you have any VARCHAR fields, a RV will send those values to the server RPADded with spaces. The server will not trim them off. With the CA, you can have the CA send trimmed values to the server.
>
>Can I have this work by attaching a remote view to a CA without actually having to set all the properties?

Well there is a CursorDetach and CursorAttach method. The CursorAttach method, according to the Help file, will attach an existing cursor to an instance of a CA and the CA inherits the corresponding properties of the cursor. However, properties like ConversionFunc where you would RTRIM character fields so VARCHAR fields are populated with trimmed data will have to be set by you.

If you use my CA VCX Builder along with the CA Builder designed for the form DE, your work will be very minimal. My builder will create a VCX containing a CA for every table in a DBC, SQL Server database or Oracle schema. You can then add any of these adapters to the DE of a form using the CA Builder from the DE. AFAIAC, the RV is gone from my toolbox. It is much easier to change a few properties of a CA when a structure changes, a backend changes or a connection type needs to change than it is to maintain an RV.

Where a CA might be too much like displaying selection data from a static lookup table, I will still use SPT to create that cursor.