>We are rewriting a large VFP app to use a SQL back-end. Unfortunately, the customers using the existing app require frequent fixes and enhancements. We don't have the manpower to maintain two separate versions of the system (the one the customers are using, and the one we are converting). What we would like to do is be able to convert the app form by form - redo a form using CAs with a SQL back-end, test it, then set the CAs to use a VFP back-end temporarily, and put the form back into the working app.
>
>The problem with this is that we really need the CA for the DEPT table, for example, to be called DEPT, or else we will need to change all the fields in the form, as well as lots of supporting code. However, I can't find any way to do this. Does anyone know of a way to do this or another workaround that would let us redo our app incrementally?
>
>TIA,
>Jen

If you use DataSourceType = [NATIVE]
You can't alias CA as VFP table name, because you always will get Alias already exists error, but if you use ADO as DataSourcetype you could ALIAS CA as you want.