Hi, this is how I do it: SELECT * FROM FOO WHERE BAR >= '2005-02-20' AND BAR < DATEADD(D, 1, '2005-02-20') Hope this helps.

Simply create a property on your Question Dialog form, which you will set with a value telling what button was selected by the user. Read the property just after calling .show method. Best wishes, Maciek

Hi I'm creating insert command object with command builder and then adding "; SELECT SCOPE_IDENTITY() as primary_key_field" formula to CommandText property of this object. I'm also setting its UpdateRowSource property to FirstReturnedRecord. After calling update method of data adapter I do not get new primary key value. I did the same without using command builder (I've created insert command object in code "manually" and it's identical to the one which is created by the command builder) and everything seems to work fine. Does someone have any idea why retrieving autoincrement value doesn't work when I use CommandBuilder? Thanks for any clues Maciek ps. If you need to see a code example, just let me know.