Search results for query: *

  • Users: vicks
  • Content: Threads
  • Order by date
  1. V

    Object of SQLParameterCollection

    SQLParameterCollection's constructor is private - so cannot directly write as - Dim objSQLParameterCollection as New SQLParameterCollection If you cannot instantiate object, then how does SQLCommand object create SQLParameterCollection object? (It returns SQLParameterCollection object with...
  2. V

    DateDiff malfunction

    DateDiff does not return me correct date difference in years : Dim dtDate1 AsDate Dim DOB AsDate DOB = #12/31/2000# dtDate1 = #1/1/2005# datediff(DateInterval.Year,dob,dtdate1) returns 5. It should return 4. It must be using "Ceil" function internally. What say?
Back
Top