[V4RB] Date-Time format problems?

[Erne]

Hi Carsten,

On 30-apr-07, at 22:32, Carsten Friehe wrote:

> Hi!
>
> I am setting the DateTime format to the following at database  
> Creation:
>       mDatabaseNew.DateSep = "."
>       mDatabaseNew.DateFormat = EVDateFormat.kMDY

maybe you should set this as kDMY

>       mDatabaseNew.TimeSep = ":"
>
> In my application I am doing the following:
>
> ---------
>   Parameter.Append Format(Datum.Day, "00") + "." + Format(Datum.Month,
> "00") + "." + Format(Datum.Year, "00") + " " + Format(Datum.Hour,  
> "00") +
> ":" + Format(Datum.Minute, "00") + ":" + Format(Datum.Second, "00")  
> + ":000"
>
>   res = pGlob.mDatabase.SqlExecute("Update Newsserver set  
> DatumAbruf = :1
> where Kontoname = '" + Newsservername + "'", Parameter)
> ---------
>
> DatumAbruf  is a DateTime field.
>
> I am getting the following error:
> ------
> 402694:Date-time value "30.04.2007 22:28:23:000" is invalid.  
> Boundary check
> error.
> ------
>
> If I look with ViSQL into the database I am getting the following  
> value
> "00.00.0000 00:00:00:000", so the format of the date-time value  
> must be ok.
> I don't know why this isn't working correctly.
>
> Best Regards,
> Carsten
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina

Cool Runnings,
Erne.

/ |\ |\  | /
– |/ | \ | –
\ |\ |  \| \