Hi Joel,

I ran into a similar situation recently while trying to document our remote views. While I admit I didn't spend a lot of time on it, I solved it with:

SELECT (lcView)
=AFIELDS(aViewColumns)
SELECT 0
CREATE TABLE doctab FROM ARRAY aViewColumns

Again, this was just quick, down and dirty get it done, but it works great!

Hope this helps,
Bob


> How do I copy the structure of a remote view in a DBC to a new DBF in the DBC with long file names.
>
>I have a remote view of an SQL table, I want to create a DBF with the same field names, but the SQL table has long field names.
>
>I thought I could use :
>
>
>
>OPEN DATABASE XX.dbc
>Use xxsqlremote_view && defined in dbc
>Browse &&works fine and I see all data
>COPY STRUCTURE TO new.dbf database XX.dbc && seems to work
>Use new &&should be structure of SQL remote view but does NOT work
>
>This always gives me an error saying :
>
>xx.dbc Cannot link table new.dbf to this database: duplicate or missing fields. Would you like to try to locate owning database or delete the link (and free the table)?