Devart Forums

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

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

The name of the table should be quoted in the query. If you generate queries with SQLiteCommandBuilder, set its Quoted property to true.