>I'm creating temporary tables with SQL Select. The resulting new tables have truncated long field names. This creates a problem, because if I do an APPEND FROM the temporary tables into the original tables the field names that do not match up are not copied. Any ideas for a solution.
Select into a cursor instead, then:
append from dbf('cursor_name')
Mark McCasland
Midlothian, TX USA