Modifying an existing database

[Gary Edge]

Thx Barney and Ruslan.
--

Best Regards,
Gary

--
On Jan 18, 2005, at 2:14 PM, Barney wrote:

> Gary,
>
> Just use a bit of code like his.
>
>   dim res as boolean
>   Dim DB as vdatabase
>   Dim BO as VBaseObject
>   Dim fld as Vfield
>
>
>   BO = App.Db.BaseObject("JobLineItems")
>   Fld = Bo.Field("DesignersFee")
>   If Fld <> Nil then
>     msgBox "Altering 'Designers Fee' field now."
>    // fld = BO.createfield( "DesignersFee", 8) //VFloats
>     Fld.Type = //Whatever type your field needs to be changed to.
>   End if
>
> In my experience all data in this field is left in tact. It might pay 
> to
> back up first just to try it though.
>
> Barney
>
>
>
>
> on 18/1/05 1:56 PM, Gary Edge at valentina at panamind.com wrote:
>
>> I've done this in a previous app but can't find reference to it in the
>> docs. (Actually I'm being a little lazy).
>>
>> I have an existing db with 10,000+ records and I need to change a 
>> short
>> field to a long field. I tried to do this with VAPP but it crashed
>> (possibly do to the db being encrypted?).
>>
>> Anyway I know this can be done on the fly to update older databases 
>> but
>> don't remember how.
>> --
>>
>> Best Regards,
>> Gary
>>
>> --
>>
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>