MS Access Syntax error (missing operator)

Question

I am using the below code to get the record from a access database. Now i got the below error Syntax error (missing operator) in query expression. I can't able to understand this issue. Please help me to fix this issue.

cmd = new OleDbCommand(@"Select * from tbl_men_schedule where fld_mem_id=" + 0 + " and  fld_startdate=" + Convert.ToDateTime(txt_startDate.Text) + " and fld_enddate=" + Convert.ToDateTime(txt_enddate.Text) + "", con);
 da = new OleDbDataAdapter(cmd);
 DataSet ds = new DataSet();
 da.Fill(ds);

Syntax error (missing operator) in query expression 'fld_mem_id=0 and  fld_startdate=1/4/2013 12:00:00 AM and fld_enddate=4/11/2013 12:00:00 AM'.

the error itself is self explanatory and suggest how you can fix. — user2063626
– user2063626, Commented Mar 16, 2013 at 3:47

HansUp · Accepted Answer · 2013-03-16 06:25:59Z

1

If fld_startdate and fld_enddate are Date/Time data type, enclose those date values with the # delimiter.

where
        fld_mem_id=0
    and fld_startdate=#1/4/2013 12:00:00 AM#
    and fld_enddate=#4/11/2013 12:00:00 AM#

If they are text data type, enclose them with quotes.

where
        fld_mem_id=0
    and fld_startdate='1/4/2013 12:00:00 AM'
    and fld_enddate='4/11/2013 12:00:00 AM'

However if you use a parameter query instead, you wouldn't need to delimit those values.

answered Mar 16, 2013 at 6:25

HansUp

97.3k11 gold badges80 silver badges139 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Piyas De · Accepted Answer · 2013-03-16 03:45:21Z

0

Your statement should be -

"Select * from tbl_men_schedule where fld_mem_id=" + 0 + " and  fld_startdate='" + Convert.ToDateTime(txt_startDate.Text) + "' and fld_enddate='" + Convert.ToDateTime(txt_enddate.Text) + "'"

Hope this helps you

answered Mar 16, 2013 at 3:45

Piyas De

1,76215 silver badges27 bronze badges

Comments

sam yi · Accepted Answer · 2013-03-16 03:52:52Z

0

If you hardcoding "0"... and you're missing single quotes.

"Select * from tbl_men_schedule where fld_mem_id=0 and fld_startdate='" + 
txt_startDate.Text + "' and fld_enddate='" + 
txt_enddate.Text + "'"

answered Mar 16, 2013 at 3:52

sam yi

4,9451 gold badge33 silver badges41 bronze badges

Collectives™ on Stack Overflow

MS Access Syntax error (missing operator)

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related