Changing a db

[jda]

>On 7/22/05 10:36 PM, "jda" <jda at his.com> wrote:
>
>>  if vdb.Table("format").StringField("sepLastNamesWith").MaxLength < 24 then
>>          call vdb.SQLExecute("ALTER TABLE format CHANGE
>>  sepLastNamesWith sepLastNamesWith String (24)")
>>           vdb.Table("format").StringField("sepLastNamesWith").IsNullable =
>>  false
>  >   end if

I also see that when I change the length, the field is moved to the 
end of the table. This is OK, but it means I have to rearrange the 
fields in the API declaration (putting the field at the end), or I 
get exceptions.

Is this the correct way?

Jon