Dear sirs,
I face a problem when I alter (change records) in a dataset a table that its name starts with a number and try to update it.
This is what I get...
SQLite error
unrecognized token: ".10_Departments"
If I change the table name just to Departments it works perfect.
My dotConnect SQLite version is 5.11.1190.0.
My app is WinForms app that uses ADO.NET in .NET Framework 4.0 and I do the following imports:
-------------------------------
Imports System.Data
Imports Devart.Data.SQLite
-------------------------------
I tried also substituting the System.Data with the Devart.Data with no result.
Any suggestions on how to face this problem?
Thanks in advance
Problem updating table that its name starts with number
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Problem updating table that its name starts with number
We have reproduced the issue. We will investigate it and post here about the results as soon as possible.
Re: Problem updating table that its name starts with number
The name of the table should be quoted in the query. If you generate queries with SQLiteCommandBuilder, set its Quoted property to true.