3 questions
Barry G. Sumpter
BarrySum at BigPond.Net.AU
Fri Oct 19 09:28:21 CDT 2007
3.
See my previous posts regarding date usage.
This is how I set the dateformat for my Valentina DB in RB2007R3
myValentinaDB.DateFormat = EVDateFormat.kYMD
myValentinaDB.Datesep = "-"
I recall only ever having to do this once.
And it stays like that.
I force the setting every time I open the db to make sure I haven't
accidentally reset it or a version release conversion has reset it.
----
I like this YYYYMMDD or YYYY-MM-DD format because you can't go wrong with
sorting either from the db or from a control.
----
This is how I retrieve the date from einhugar DateControl
strStartDate = dtStart.DateValue.SQLDate
strEndDate = dtEnd.DateValue.SQLDate
----
This is how I set the DateTime stamp for updating a Valentina date field
Dim dt as Date
dt = New Date
dim strLastUpdated As String
strLastUpdated = dt.SQLDateTime
sql = "UPDATE Menus "
sql = sql + "SET Num = '" +strNum + "' , "
sql = sql + "StartDate = '" + strStartDate + "' , "
sql = sql + "EndDate = '" + strEndDate + "', "
sql = sql + "Description = '" + efDescription.text + "', "
sql = sql + "Status = '" + str(intStatus) + "', "
sql = sql + "LastUpdated = '" + strLastUpdated + "' "
sql = sql + "WHERE RecID = " + stRecID.text
hth
-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Joseph Morgan
Sent: Friday, 19 October 2007 8:54 PM
To: Valentina Developers
Subject: 3 questions
Hello:
1. What does this do?:
2. What is 'v' parameter?:
vrdatabase.getproperty(v as string)
3. In v4rb all my dates are returned in 'mm/dd/yyyy' format
but I set them to 'yyyy-mm-dd' in vstudio. Selects in vstudio return
in 'yyyy-mm-dd'
format. Am I doing something wrong? Or is this a bug?
Thanks,
Joseph
_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
More information about the Valentina
mailing list