Modifying an existing database

[Gary Edge]

I may be having a different problem. I'm storing a value representing a 
length of time in seconds. One particular value is 624 minutes (624 * 
60 = 37440 seconds). Executing a query with the sec_to_time method 
returns correct values for all except this entry which returns 
-07:48:16.

~65k is the maximum value for a VShort field correct?

Any thoughts on why this value is returned?
--

Gary

--
On Jan 18, 2005, at 3:44 AM, Ruslan Zasukhin wrote:

> On 1/18/05 2:56 AM, "Gary Edge" <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?).
>
> Of course. VAPP do not work with encrypted dbs.
>
>> Anyway I know this can be done on the fly to update older databases 
>> but
>> don't remember how.
>
> VBaseObject.ChangeType() method
>
> -- 
> Best regards,
> Ruslan Zasukhin      [ I feel the need...the need for speed ]
> -------------------------------------------------------------
> e-mail: ruslan at paradigmasoft.com
> web: http://www.paradigmasoft.com
>
> To subscribe to the Valentina mail list go to:
> http://lists.macserve.net/mailman/listinfo/valentina
> -------------------------------------------------------------
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>