General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Copy structure to new.dbf database xx.dbc works for me in VFP 6 with databases with long field names and fieldnames that have the same first 10 characters. Does your remote view have field names with illegal characters or embedded spaces? I think that this would cause the error you are seeing.
OOPS, please disregard this post. Just checked and illegal characters or embedded spaces cause the field names in the remote view to be changed using underscores where fieldname "long field name #1" is changed to "long_field_name_1" in the remote view. Copy to command still copied structure of the remote view to a new table preserving these changed long field names.
>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)?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only