Jet 4.0 SQL statement - empty records RRS feed

  • Question

  • In my project I use a data adapter to create a single table dataset from where I can work via dataview with my data.  My data is in an Access database and I use the MS Jet 4.0.oledb provider to connect.


    My question is how to create a "SELECT * FROM WHERE" statement if I want to populate the dataset with rows where I have no values in one of my date columns.  The statement that I used that does not want to work is

    "SELECT * FROM ReqSampleT WHERE DatePerformed = ' '"

    Thursday, May 29, 2008 12:13 PM


All replies