title: Problem with Insert query to Paradox table using C#
body: <p>I have Paradox 5.x tables I need to connect to in order to select and update.
  I am using OLEDBConnection.</p>
  <p>selecting from the tables I have no problem.
  while trying to insert into the tables I met a problem when I entered hardcoded the fields names I got an error:
  The INSERT INTO statement contains the following unknown field name: ...
  so I used OleDbDataReader.GetName(...) to get fields names.
  now I use the fields names received from table in order to insert into table and I still get the same error.</p>
  <p>I think the problem is with the field name: 'Truck #1 Serial Number'
  Table name: 'Vehicles'</p>
  <p>I tried using [], .&quot;&quot;, .[] and
  .[&quot;&quot;].</p>
  <p>I have read about the need of Borland engine but I'm not sure this is the issue.
  Thanks upfront.</p>
  <p>-=Noam=-</p>
  <p>p.s I cannot change name of tables since its a customer DB I need to connect.</p>
  <p>Im adding the C# code I use:</p>
  <pre><code>private static string createInsertQueryVehicle(string i_VehicleNumber, string i_VehicleMFG, string i_Truck1SerialNo, string i_Truck2SerialNo, string i_Truck3SerialNo)
          {
              string tryout = string.Format(&quot;INSERT INTO {0} ([{6}], [{7}], [{8}], [{9}], [{10}]) VALUES(RIGHT('{1}',10),'{2}','{3}','{4}','{5}')&quot;,
                  TableName, Vnum, Vinfo, T1Serial, T2Serial, T3Serial, VnumFieldName, VinfoFieldName, T1SerialFieldName
                  T2SerialFieldName,T3SerialFieldName);
              return tryout;
          }
  </code></pre>
  <p>at end tryout holds:</p>
  <pre><code>INSERT INTO Vehicles ([Vehicle Number], [Vehicle Mfg], [Truck #1 Serial Number], [Truck #2 Serial Number], [Truck #3 Serial Number]) VALUES(RIGHT('000000010001525',10),'קרונות משא','ר40011_1','ר40011_2','')
  </code></pre>
  <p>EDIT:
  Just wanted to add my solution at end:
  At the end the best solution I could get was to use accesses as the connection point using linked tables to the paradox tables, at end handling it as an accesses DB.....
  Hope it helps someone.</p>