[V4RB] Changing Database structure

[Stan R. Busk]

Hi,

You mean this way: ?

   dim i as integer
   dim inFile as FolderItem
   dim vdb as vDatabase

   vdb = new vDataBase

   if vdb.open(inFile) then
     i = vdb.SQLExecute("COMMAND")
     vdb.close
   end

Stan

> Stan,
> And note, you need open database using Vdatabase class. NOT mydatabase.
> Then you check version, if needed you Update structure, and close 
> Vdatabase
> object.
> Then open db as myDatabase.

>>> I wonder what is the best way to convert an existing static database
>>> once you add a new field to one of its tables. I guess you need to
>>> write a tool that create a new file with new structure, open old file
>>> with old structure and copy all data from the first to the latter. Am
>>> I true? Is there a better / easier way?
>>
>> I don't know whether it is easier or not. It is your decission.
>> I do the following: Opening database and checking which version 
>> database is.
>> If databaseversion is not the actual one then calling update-method
>> after update-method until the database-version is actual.
>> After that I give the message (information) that the database is
>> updated. thats it. When you want to get more information or example 
>> code. tell me.

-- 
MAX Programming, LLC
<http://maxprog.com>