Copying new Fields 'WITH PRODUCTION'

[andyk]

Hi All,

I recently had a problem whereby I had two tables, both containing a field named 'f_name' joined by a single view. The problem was that the view seemed to not be able to resolve where the updates should go for each of the corresponding 'f_name' view fields (I used appropiate aliases in the view).

To get around this problem I eventually decided to rename one of the fields to 'f_emps_name'. This solved the orginal problem but now I have a problem when I do the following:

copy to c:\temp\employees.dbf with production

I get the error:

Variable 'f_emps_name' is not found.

The renamed field is referenced in one index and as I don't get the error when I do the 'copy to' without the 'with production' clause I assume it's the index which is causing the problem.

Can anyone help?

Thanks Andy

 

[Mike Gagnon]

andyk

Your problem is related to the fact that your original table comes most likely from a database that allows long field names (11). And when you copy that table, it becomes a free table that won't permit long field names. You should recude the name of the field by one character, the limit for a free table is 10, so call it "f_emps_nam". Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[andyk]

Mike,

Top man! - Thanks problem solved

Cheers Andy