Altering table

[Ruslan Zasukhin]

On 7/2/05 8:53 PM, "jda" <jda at his.com> wrote:

> I'm trapping the exception and trying to alter the table (to make a
> field NOT indexedbywords). But it is not altering the database!
> 
> Here is the code. What am I doing wrong?
> 
>      try
>        localFormatDB.open(formatFolderItem)
>      catch theError as VException
>        if theError.ErrorNumber =  525583 then //propertyName is
> indexedbywords. remove that.
>          if localFormatDB <> nil and localFormatDB.isOpen then
>            localFormatDB.close
>          end if
>          vdb = new VDatabase
>          vdb.open(formatFolderItem)
>          if vdb <> nil then
>  
> vdb.Table("bibAndDoc").StringField("propertyName").indexByWords =
> false
>            vdb.Table("bibAndDoc").Field("propertyName").isIndexed = false
>            vdb.flush
>            vdb.close
>            vdb = nil
>          end if
>          localFormatDB.open(formatFolderItem) -> STILL throws an
> error. And the db is not updated.
>        else
>          raise theError
>        end if
>      end try

Ivan will check now

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]