3 questions

[Barry G. Sumpter]

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