Is it possible to make a VText field that is not nullable? I have an existing database where I have many VText fields that were created as nullable:
authors = CreateTextField("authors", 128, EVFlag.fNullable + EVFlag.fIndexed + EVFlag.fIndexByWords)
I have rewritten the constructor to use this
authors = CreateTextField("authors", 128, EVFlag.fIndexed + EVFlag.fIndexByWords)
But when I create a new database I see this when I examine the authors field in VStudio
authors [I:N:W]
Also, in trying to update an existing database, I open the database and try to convert nullable fields to non-nullable fields
for i = 1 to vdb.Table("thetable".FieldCount
if vdb.Table("thetable".Field(i).IsNullable then
vdb.Table("thetable".Field(i).IsNullable = false
end if
next
Many fields do have isNullable set to false when the code is executed, but when I check immediately thereafter they are still nullable. For example, running the above code twice in a row catches the same fields in both.