VCursur Insert Query for date time format errors

[Mahesh Markus]

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