>We have to have a table with fields in a specific order to upload to a mainframe. The field names do not matter, just the location of the fields. I want to be able to take any table that has 52 fields with each having the correct data type and size and add 4 fields to it in a specific place. I looked a the FAQ and one answer I found referred to a bubble sort but that is to complicated for the number of fields. The problem is other table fields may have different names and record size is too large for an array (which is what got me here in the first place). I currently use SQl with space() as fieldname to add fields, into array and append from array, but data is too large for array. Any ideas?
>
>Thanks, Chuck
You can create another copy of the table, adding the four fields manually with CREATE STRUCTURE, or duplicating the entire structure with CREATE TABLE. Then, you can do an APPEND FROM.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
