Hi.

I'm trying to make a criteria string to use in Select() method of a datatable, searching for a date, but it is apparently not working!

In one of my tests, I have a datatable with 1 row and a field containing the following value (extracted from Immediate Window):

?dtbSample.Rows(0).Item("COM_STARTDATE")
#5/8/2006 9:00:00 AM# {Date}
Date: #5/8/2006 9:00:00 AM#
(for better understand, consider this date as '2006/05/08')


Then, I test a criterium to DON'T show that row, using this:
arrRows = dtbSample.Select("COM_STARTDATE >= '2006/05/09'")

Now, look the results in immediate window:
?arrRows.Length
1

!!!!!!
The Select() is returning a DataRow with a date less than the specified criterium, which is requiring a date higher than existing in the DataTable!!
In resume, '2006/05/08' is less than "COM_STARTDATE >= '2006/05/09'", but is returning like if '2006/05/08' is higher.

Someone already noticed that behaviour? There is a way to fix it?


Cesar

ps.:
For you know, I tryied to build criteria like below and still is returning row (not working):


("COM_STARTDATE >= #'2006/05/09#") 'yyyy/MM/dd and #
("COM_STARTDATE >= '05/09/2006'") 'MM/dd/yyyy
("COM_STARTDATE >= '" & TheDate.ToString & "'") 'a Date datatype
("COM_STARTDATE >= #05/09/2006#") 'MM/dd/yyyy and #
("COM_STARTDATE >= #May/09/2006#") 'MMM/dd/yyyy and #

I repeat, these don't works!! They are returning the row.    :^P

Cesar,
I suspect that '2006/05/09' is not being translated properly.

Try:

arrRows = dtbSample.Select("COM_STARTDATE >= #05/09/2006#")


As Date values in DataSet expressions need to be delimited by #.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatadatacolumnclassexpressiontopic.asp

I believe the date values are in m/d/y format.


Something like:

        Dim table As New DataTable
        table.Columns.Add("COM_STARTDATE", GetType(DateTime))
        table.Rows.Add(#5/8/2006 9:00:00 AM#)

        Dim rows() As DataRow = table.Select("COM_STARTDATE >=
#05/09/2006#")


I'm trying to make a criteria string to use in Select() method of a
datatable, searching for a date, but it is apparently not working!

In one of my tests, I have a datatable with 1 row and a field containing the
following value (extracted from Immediate Window):

?dtbSample.Rows(0).Item("COM_STARTDATE")
#5/8/2006 9:00:00 AM# {Date}
Date: #5/8/2006 9:00:00 AM#
(for better understand, consider this date as '2006/05/08')


Then, I test a criterium to DON'T show that row, using this:
arrRows = dtbSample.Select("COM_STARTDATE >= '2006/05/09'")

Now, look the results in immediate window:
?arrRows.Length
1

!!!!!!
The Select() is returning a DataRow with a date less than the specified
criterium, which is requiring a date higher than existing in the DataTable!!
In resume, '2006/05/08' is less than "COM_STARTDATE >= '2006/05/09'", but is
returning like if '2006/05/08' is higher.

Someone already noticed that behaviour? There is a way to fix it?


Cesar

ps.:
For you know, I tryied to build criteria like below and still is returning
row (not working):


("COM_STARTDATE >= #'2006/05/09#") 'yyyy/MM/dd and #
("COM_STARTDATE >= '05/09/2006'") 'MM/dd/yyyy
("COM_STARTDATE >= '" & TheDate.ToString & "'") 'a Date datatype
("COM_STARTDATE >= #05/09/2006#") 'MM/dd/yyyy and #
("COM_STARTDATE >= #May/09/2006#") 'MMM/dd/yyyy and #

I repeat, these don't works!! They are returning the row.    :^P

I tryied # also, like showed in PS area, at end of e-mail  :D

But the problem was the rows not commited, and the Select() only searches in commited data.
I posted the solution in a other reply.

Thanks anyway, for response.

[]s
Cesar



Show quoteHide quote

OUCH! Found it... the Select() method by default, searches only for commited data.... and my DataRow was not yet commited by the AcceptChanges() method.

Then, to fix it, i should use:
arrRows = dtbSample.Select("COM_STARTDATE >= #May/09/2006#", "", DataViewRowState.ModifiedCurrent)

The third parameter now makes the method works like I want.

[]s
Cesar







  I'm trying to make a criteria string to use in Select() method of a datatable, searching for a date, but it is apparently not working!

  In one of my tests, I have a datatable with 1 row and a field containing the following value (extracted from Immediate Window):

  ?dtbSample.Rows(0).Item("COM_STARTDATE")
  #5/8/2006 9:00:00 AM# {Date}
  Date: #5/8/2006 9:00:00 AM#
  (for better understand, consider this date as '2006/05/08')


  Then, I test a criterium to DON'T show that row, using this:
  arrRows = dtbSample.Select("COM_STARTDATE >= '2006/05/09'")

  Now, look the results in immediate window:
  ?arrRows.Length
  1

  !!!!!!
  The Select() is returning a DataRow with a date less than the specified criterium, which is requiring a date higher than existing in the DataTable!!
  In resume, '2006/05/08' is less than "COM_STARTDATE >= '2006/05/09'", but is returning like if '2006/05/08' is higher.

  Someone already noticed that behaviour? There is a way to fix it?


  Cesar

  ps.:
  For you know, I tryied to build criteria like below and still is returning row (not working):


  ("COM_STARTDATE >= #'2006/05/09#") 'yyyy/MM/dd and #
  ("COM_STARTDATE >= '05/09/2006'") 'MM/dd/yyyy
  ("COM_STARTDATE >= '" & TheDate.ToString & "'") 'a Date datatype
  ("COM_STARTDATE >= #05/09/2006#") 'MM/dd/yyyy and #
  ("COM_STARTDATE >= #May/09/2006#") 'MMM/dd/yyyy and #

  I repeat, these don't works!! They are returning the row.    :^P

Hmmm... After some testes, I noticed that the value DataViewRowState.CurrentRows works better than the previous I told.

Example:
arrRows = dtbSample.Select(strCrit, "", DataViewRowState.CurrentRows)

[]s
Cesar

  OUCH! Found it... the Select() method by default, searches only for commited data.... and my DataRow was not yet commited by the AcceptChanges() method.

  Then, to fix it, i should use:
  arrRows = dtbSample.Select("COM_STARTDATE >= #May/09/2006#", "", DataViewRowState.ModifiedCurrent)

  The third parameter now makes the method works like I want.

  []s
  Cesar







    Hi.

    I'm trying to make a criteria string to use in Select() method of a datatable, searching for a date, but it is apparently not working!

    In one of my tests, I have a datatable with 1 row and a field containing the following value (extracted from Immediate Window):

    ?dtbSample.Rows(0).Item("COM_STARTDATE")
    #5/8/2006 9:00:00 AM# {Date}
    Date: #5/8/2006 9:00:00 AM#
    (for better understand, consider this date as '2006/05/08')


    Then, I test a criterium to DON'T show that row, using this:
    arrRows = dtbSample.Select("COM_STARTDATE >= '2006/05/09'")

    Now, look the results in immediate window:
    ?arrRows.Length
    1

    !!!!!!
    The Select() is returning a DataRow with a date less than the specified criterium, which is requiring a date higher than existing in the DataTable!!
    In resume, '2006/05/08' is less than "COM_STARTDATE >= '2006/05/09'", but is returning like if '2006/05/08' is higher.

    Someone already noticed that behaviour? There is a way to fix it?


    Cesar

    ps.:
    For you know, I tryied to build criteria like below and still is returning row (not working):


    ("COM_STARTDATE >= #'2006/05/09#") 'yyyy/MM/dd and #
    ("COM_STARTDATE >= '05/09/2006'") 'MM/dd/yyyy
    ("COM_STARTDATE >= '" & TheDate.ToString & "'") 'a Date datatype
    ("COM_STARTDATE >= #05/09/2006#") 'MM/dd/yyyy and #
    ("COM_STARTDATE >= #May/09/2006#") 'MMM/dd/yyyy and #

    I repeat, these don't works!! They are returning the row.    :^P

Working more, I got another problems with some other uses for select()... After break the head a bit more, I found that DataBindings was the root for causing all the troubles. Then, after I set:

BindingContext(dtb).SuspendLayout()

... when the form closes, everything work like nothing was happened.
And then, I even dont needed that 3rd parameter in the Select() commands I used. Rewrote everything again. :D

[]s
Cesar


  Hmmm... After some testes, I noticed that the value DataViewRowState.CurrentRows works better than the previous I told.

  Example:
  arrRows = dtbSample.Select(strCrit, "", DataViewRowState.CurrentRows)

  []s
  Cesar

    OUCH! Found it... the Select() method by default, searches only for commited data.... and my DataRow was not yet commited by the AcceptChanges() method.

    Then, to fix it, i should use:
    arrRows = dtbSample.Select("COM_STARTDATE >= #May/09/2006#", "", DataViewRowState.ModifiedCurrent)

    The third parameter now makes the method works like I want.

    []s
    Cesar







      Hi.

      I'm trying to make a criteria string to use in Select() method of a datatable, searching for a date, but it is apparently not working!

      In one of my tests, I have a datatable with 1 row and a field containing the following value (extracted from Immediate Window):

      ?dtbSample.Rows(0).Item("COM_STARTDATE")
      #5/8/2006 9:00:00 AM# {Date}
      Date: #5/8/2006 9:00:00 AM#
      (for better understand, consider this date as '2006/05/08')


      Then, I test a criterium to DON'T show that row, using this:
      arrRows = dtbSample.Select("COM_STARTDATE >= '2006/05/09'")

      Now, look the results in immediate window:
      ?arrRows.Length
      1

      !!!!!!
      The Select() is returning a DataRow with a date less than the specified criterium, which is requiring a date higher than existing in the DataTable!!
      In resume, '2006/05/08' is less than "COM_STARTDATE >= '2006/05/09'", but is returning like if '2006/05/08' is higher.

      Someone already noticed that behaviour? There is a way to fix it?


      Cesar

      ps.:
      For you know, I tryied to build criteria like below and still is returning row (not working):


      ("COM_STARTDATE >= #'2006/05/09#") 'yyyy/MM/dd and #
      ("COM_STARTDATE >= '05/09/2006'") 'MM/dd/yyyy
      ("COM_STARTDATE >= '" & TheDate.ToString & "'") 'a Date datatype
      ("COM_STARTDATE >= #05/09/2006#") 'MM/dd/yyyy and #
      ("COM_STARTDATE >= #May/09/2006#") 'MMM/dd/yyyy and #

      I repeat, these don't works!! They are returning the row.    :^P

Ronchese,

That the Select is buggy is in my idea not even testable because the lack of documentation around the Expression.

However, AFAIK has a date in the select in VB to be the USA date literal as you have used in your example. The Expression is AFAIK totaly based on USA behaviour.

I hope this helps a little bit.

Cor
  I'm trying to make a criteria string to use in Select() method of a datatable, searching for a date, but it is apparently not working!

  In one of my tests, I have a datatable with 1 row and a field containing the following value (extracted from Immediate Window):

  ?dtbSample.Rows(0).Item("COM_STARTDATE")
  #5/8/2006 9:00:00 AM# {Date}
  Date: #5/8/2006 9:00:00 AM#
  (for better understand, consider this date as '2006/05/08')


  Then, I test a criterium to DON'T show that row, using this:
  arrRows = dtbSample.Select("COM_STARTDATE >= '2006/05/09'")

  Now, look the results in immediate window:
  ?arrRows.Length
  1

  !!!!!!
  The Select() is returning a DataRow with a date less than the specified criterium, which is requiring a date higher than existing in the DataTable!!
  In resume, '2006/05/08' is less than "COM_STARTDATE >= '2006/05/09'", but is returning like if '2006/05/08' is higher.

  Someone already noticed that behaviour? There is a way to fix it?


  Cesar

  ps.:
  For you know, I tryied to build criteria like below and still is returning row (not working):


  ("COM_STARTDATE >= #'2006/05/09#") 'yyyy/MM/dd and #
  ("COM_STARTDATE >= '05/09/2006'") 'MM/dd/yyyy
  ("COM_STARTDATE >= '" & TheDate.ToString & "'") 'a Date datatype
  ("COM_STARTDATE >= #05/09/2006#") 'MM/dd/yyyy and #
  ("COM_STARTDATE >= #May/09/2006#") 'MMM/dd/yyyy and #

  I repeat, these don't works!! They are returning the row.    :^P

Internet connectivity
Saving Blob Data To File
How to disable the numericupdown event firing?
Question en programmation !
Transparent Listbox...
Need to lock read a text file, then delete...
Dataset or SQL? wich is faster?
Check if Service is running?
How to kill a terminal server session (VB.NET)
Safe / Unsafe Native Methods