Syntax error missing operator in query expression

• Remove From My Forums

• Question

• I have one select statement to execute on the access database on the click of a button. when i click on the button i am getting this error «Syntax error (missing operator) in query expression ‘Customer_Name = Summer Terry’.» The code that
  i have written is pasted below and also the error log. Can anyone please find and correct the error in my code.

  using System;
  using System.Collections.Generic;
  using System.ComponentModel;
  using System.Data;
  using System.Drawing;
  using System.Text;
  using System.Windows.Forms;
  using System.Data.OleDb;
  
  namespace Cyber_Application
  {
      public partial class RegularCustomer : Form
      {
          int flag = 0;
          string currentFile;
          string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\Clients\S V Cyber Cafe\Cyber Application\Cyber Application\param.accdb; Jet OLEDB:Database Password=12345";
  
          public RegularCustomer()
          {
              InitializeComponent();
          }
  
          private void btnOK_Click(object sender, EventArgs e)
          {
              string address = "";
              string date = "";
              string InTime = "";
              string OutTime = "";
              date = DateTime.Now.ToShortDateString();
              address = txtAddress.Text;
              InTime = txtInHour.Text + ":" + txtInMin.Text + " " + listBoxIn.SelectedItem.ToString();
              OutTime = txtOutHour.Text + ":" + txtOutMin.Text + " " + listBoxOut.SelectedItem.ToString();
              MessageBox.Show("Your address is:n" + address + "nToday's date is:n" + date + "nYour In Time is:n" + InTime + "nYour Out Time is:n" + OutTime);
          }
  
          private void btnCancel_Click(object sender, EventArgs e)
          {
              this.Close();
          }
  
          private void addCustomers()
          {
              OleDbConnection cn = new OleDbConnection(connectionString);
              OleDbCommand cmd = new OleDbCommand("select Customer_Name from Customers", cn);
              cn.Open();
              OleDbDataReader dr = cmd.ExecuteReader();
  
              if (dr != null)
              {
                  while (dr.Read())
                  {
                      cBoxCustomers.Items.Add(dr["Customer_Name"]);
                  }
              }
              cBoxCustomers.SelectedIndex = 0;
          }
  
          private void RegularCustomer_Load(object sender, EventArgs e)
          {
              addCustomers();
              btnOK.Enabled = false;
              btnBrowse.Enabled = false;
              btnSelectCustomer.Enabled = false;
              txtName.Enabled = false;
              txtAddress.Enabled = false;
              txtContactNo.Enabled = false;
              txtIdProof.Enabled = false;
              txtIssuedBy.Enabled = false;
          }
  
          private void cBoxCustomers_SelectedIndexChanged(object sender, EventArgs e)
          {
              if (cBoxCustomers.SelectedIndex == 0)
              {
                  btnSelectCustomer.Enabled = false;
              }
              else
              {
                  btnSelectCustomer.Enabled = true;
              }
          }
  
          private void btnSelectCustomer_Click(object sender, EventArgs e)
          {
              using (OleDbConnection cn = new OleDbConnection(connectionString))
              {
                  cn.Open();
                  string scmd = "select [Customer_Name], [Address], [Contact_No], [Gender], [Issued_By] from Regular_Customers where Customer_Name = " + cBoxCustomers.SelectedItem.ToString();
                  OleDbCommand cmd = new OleDbCommand(scmd, cn);
                  OleDbDataReader sdr = cmd.ExecuteReader();
                  while (sdr.Read())
                  {
                      txtName.Text = sdr[0].ToString(); ;
                      txtAddress.Text = sdr[1].ToString();
                      txtContactNo.Text = sdr[2].ToString();
                      
                      if (sdr[3].ToString() == "M")
                      {
                          radioBtnMale.Select();
                      }
  
                      if (sdr[3].ToString() == "F")
                      {
                          radioBtnFemale.Select();
                      }
  
                      txtIssuedBy.Text = sdr[4].ToString();
                  }
              }
          }
      }
  }
  
  

  The error code is:

  System.Data.OleDb.OleDbException was unhandled
    Message=Syntax error (missing operator) in query expression 'Customer_Name = Summer Terry'.
    Source=Microsoft Office Access Database Engine
    ErrorCode=-2147217900
    StackTrace:
         at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
         at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
         at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
         at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
         at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
         at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
         at System.Data.OleDb.OleDbCommand.ExecuteReader()
         at Cyber_Application.RegularCustomer.btnSelectCustomer_Click(Object sender, EventArgs e) in E:ClientsS V Cyber CafeCyber ApplicationCyber ApplicationRegularCustomer.cs:line 90
         at System.Windows.Forms.Control.OnClick(EventArgs e)
         at System.Windows.Forms.Button.OnClick(EventArgs e)
         at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
         at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
         at System.Windows.Forms.Control.WndProc(Message& m)
         at System.Windows.Forms.ButtonBase.WndProc(Message& m)
         at System.Windows.Forms.Button.WndProc(Message& m)
         at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
         at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
         at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
         at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
         at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
         at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
         at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
         at System.Windows.Forms.Application.Run(Form mainForm)
         at Cyber_Application.Program.Main() in E:ClientsS V Cyber CafeCyber ApplicationCyber ApplicationProgram.cs:line 17
         at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)
         at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
         at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
         at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
         at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
         at System.Threading.ThreadHelper.ThreadStart()
    InnerException: 
  
  

  • Edited by

    Monday, September 26, 2011 3:30 AM

Be The First To Get Support Updates

Want to know about the latest technical content and software updates?

This message is returned during Interactive Selection on Access GeoDatabase:

There was an error executing the query.
General Function Failure [1layer_name]
Syntax error (missing operator) in query expression ‘(1layer_name.OBJECTID = 1layer_name_Shape_Index.IndexedObjectId and MaxGx >= 2 and MinGX <= 2 and MaxGY> = 0 and MinGY <= 0)’.

Personal Geodatabase Access layer features cannot be selected if the name of the layer starts with a number.

Note:
Database management systems have different definitions of acceptable characters for object names. Most names must begin with a letter and cannot contain spaces, backslashes, or reserved database management system keywords. Some databases allow special characters such as forward slashes (/), underscores (_), dollar signs ($), dashes (-), dots (.), or mixed cases. Sometimes the database allows you to use special characters or reserved keywords, or force mixed, upper-, or lowercase names if you provide the object name enclosed in delimiters, such as double quotation marks.

However, ArcGIS does not delimit object names. Do not create any tables, feature classes, indexes, databases, users*, roles, or other object names that require delimiters if you will be using them with ArcGIS. The object will be created in the database, but you cannot access it from ArcGIS.

*SQL Server user names containing special characters are delimited to fully support Active Directory Groups and Windows Authenticated logins; however, ArcGIS does not support user names containing single quotation marks or apostrophes.

Rename the Feature layer to not begin with a number.

• What is a personal geodatabase?

Last Published: 7/9/2019

Article ID: 000002818