VCursur Insert Query for date time format errors

[Mahesh Markus]

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