VCursur Insert Query for date time format errors

[Mahesh Markus]

Sorry, I set the date format when the database is created, and not when
it is opened.

If use SetDateTimeFormat when it is opened, then the the return value
from GetDateTimeFormat is correct.

However, I would have thought that the DateTimeFormat persists when the
database is created.

Mahesh

-----Original Message-----
From: Mahesh Markus 
Sent: Thursday, 12 February 2004 5:29
To: Valentina Developers
Subject: RE: VCursur Insert Query for date time format errors


I also set the Date format after the database is open.

-----Original Message-----
From: Mahesh Markus 
Sent: Thursday, 12 February 2004 5:28
To: Valentina Developers
Subject: RE: VCursur Insert Query for date time format errors


I don't have a copy of Valentina Studio. 

I use ViSQL to develop my queries.

Mahesh

-----Original Message-----
From: Ruslan Zasukhin [mailto:sunshine at public.kherson.ua] 
Sent: Thursday, 12 February 2004 5:12
To: valentina at lists.macserve.net
Subject: Re: VCursur Insert Query for date time format errors


on 2/12/04 7:46 AM, Mahesh Markus at maheshm at uniqueworld.net wrote:

> I have a valentina db, which has the dateformat set to [2, "/", ":", 
> 20]
> 
> However, an "INSERT" sql query (using vCursur ) will insert the 
> correct date if and only if the date format is "D/M/Y"
> 
> How do I make sure that the INSERT sql queries with a date format 
> "Y/M/D" will put in the correct values?

I will check this.

BTW, you also can easy check your db in Valentina Studio
To see that you have format 2

That Valentina Studio then correctly show dates in YMD
And that INSERT query do what you need.

Do you set date format to a database AFTER its open ?

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