Hi Victor,

I'm glad you heard of xCase2VPM. What you wouldn't know if you hadn't used it, or watched the client-server demo at www.prosysplus.com/csdemo.htm, is that xCase2VPM provides much functionality that xCase does not provide:

-- xcase2vpm auto-creates all the extra views that enable VPM functionality; these are complex views with parameters for the PK, built separately with a parameter for each incoming (FK) relation, and including find parameters that auto-allow user selection by the user-selected (in xCase, using added attributes) fields.

-- xCase2VPM creates the list definitions for each entity (based on user specification in xCase) that, combined with the ProSysPlus subclasses and the native VPM functionality, provides a Selection List for each form, without further user intervention. The same list definitions are put into the VPM data dictionary as the default (everything is overridable that can be) Foreign Key selection list definition (a native VPM functionality).

-- xCase2VPM modifies the "remote" xCase model to ensure it will transport correctly to the backend (VPM takes care of defaults, e.g., and that's good, because SQL doesn't handle VFP functions very well <s>).

-- xCase2VPM creates the Remote dbc and remote views that allow seamless (and selective, by view) switching between local and remote views.

There's a lot more. A free fully functional 5-entity demo is available at www.prosysplus.com/products/xcase2vpm.htm.

I'm sure you'll be delighted to know that Aaron is one of the most active users of xCase2VPM. <s>

cheers,

Hank