Warning, but I don't see the error

[jda]

>There are two other fields (methods) that i see I made a mistake in 
>when contructing them. They are just indexes by word, but they are 
>indexing the wrong field.
>
>Can I fix this by doing some kind of redefinition of them? Or must I 
>delete them and then recreate them?
>

To follow up my own question. I didn't see a way to change/modify a 
method in place, so I did this:

       call vdb.SQLExecute("ALTER table thereferences DROP user17SortMethod")
       call vdb.SQLExecute("ALTER table thereferences DROP user18SortMethod")

       call 
vdb.Table("thereferences").CreateVarCharField("user17SortMethod", 16, 
EVFlag.fNullable, "left(user17", 16)")
       call 
vdb.Table("thereferences").CreateVarCharField("user18SortMethod", 16, 
EVFlag.fNullable, "left(user18", 16)")

Now the order of the fields in the schema is changed (the last two 
methods are at the end), but Valentina doesn't seem to mind -- the db 
opens in the new version with the updated schema without a warning.

Is this OK to do?

Jon