VTime in V4RB2.4.2

[Ruslan Zasukhin]

On 9/24/06 2:17 PM, "Beatrix Willius" <bwillius at gmx.de> wrote:

Hi Beatrix, 

> Since updating to 2.4.2 I have a problem with a time field. The
> following code
> 
>    dim mTable as VTable
>    mTable = mDatabase.CreateTable("Message")
>    dim MainDate as VDate = new VDate("MainDate")
>    dim MainTime as VTime = new VTime("MainTime")

>    dim theCursor as VCursor = mDatabase.SqlSelect("select * from
> message", EVCursorLocation.kServerSide, EVLockType.kNoLocks,
> EVCursorDirection.kRandom)

>    theCursor.SetBlank
>    dim theDate as new Date
>    theCursor.Field("MainDate").setString(theDate.ShortDate)
>    theCursor.Field("MainTime").setString(theDate.LongTime)
>    theCursor.Field("MainTime").setString("08:15:17:234")
> 
> gives a VException for the first line with MainTime (Time Value "xxx"
> is invalid. Illegal Value at "8" position.). The second line works.

> Has anything been changed for 2.4.2? Is this a bug or a feature?

Yes 2.4.2 adds VERY STRICT checks of date and time strings.

You cannot send e.g. String with HH = 25
Or  "22: 45"
       ^^^ space 

So problem is with 
>    theCursor.Field("MainTime").setString(theDate.LongTime)

What string RB returns ?


-- 
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]