Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Comparing date in OleDb

Status
Not open for further replies.

arneweise77

Programmer
Apr 25, 2002
46
SE
Hi!
I´m using a simple datagrid that gets data from MS Access. Then the user have the chose to display rows in the datagrid with a certain date. The user types this in a textbox.

My problem is that a then want to make SQL-statement like:
"select * FROM myDataBase WHERE date = 2001-01-01"
I´m using OleDb, but I keep getting an exception:
"No value given for one or more required parameters"

 
Ooops! Sorry about that guys, pretty tired today. Selected from wrong table...

Well I´m man enough to admit it, give me that!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top